uninclude chart data

[owaring]

have a chart that displays up to 20 series of data.

how ever in some instances not all 20 are present in which case the chart reads this data as values of 0

this is a problem as all the data is between 800 and 900, and as soon as a 0 is plotted the chart axis becomes to wide, and the chart becomes ilegable.

how can i get the chart to uninclude data of 0?

[Bryan Hessey]

have a chart that displays up to 20 series of data.

how ever in some instances not all 20 are present in which case the chart reads this data as values of 0

this is a problem as all the data is between 800 and 900, and as soon as a 0 is plotted the chart axis becomes to wide, and the chart becomes ilegable.

how can i get the chart to uninclude data of 0?

Select the gridline and rightmouse Format Gridlines, set Minimum to 800

---

[owaring]

thanks for that, however it would be nice to keep the auto axis function if possible.

would there be a way to set the min/max of the axis to refer to a cell value, i could then do a min and max function to set axis from. that way any zero values would be ignored.

[Bryan Hessey]

thanks for that, however it would be nice to keep the auto axis function if possible.

would there be a way to set the min/max of the axis to refer to a cell value, i could then do a min and max function to set axis from. that way any zero values would be ignored.

It is quite possible that the item xlMinorGridlines, a member of xlChartItem would be an area to begin any search, providing that you know VB code. I am not aware of any non-VBA method.

--

[owaring]

just started to type out my solution but figured it was that convoluted you'd think i was nuts!!

thanks for the help though!

[Bryan Hessey]

just started to type out my solution but figured it was that convoluted you'd think i was nuts!!

thanks for the help though!

Another possibility is to run your chart from a copy of your data whereby instead of setting the copy =A1 you set it to =If(A1<800,800,A1), perhaps using B1 either as a set range =If(A1<B1,B1,A1), or as a calculated figure (in b1) =Min(A1:A30)

hth
---