Thread: uninclude chart data

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?

Originally Posted by 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?

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

---

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.

Originally Posted by 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.

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.

--

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

thanks for the help though!

Originally Posted by 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!

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
---