Excell 2010 Charting blank values with Auto Axis

**Dial1** · 11-14-2012, 04:29 PM

I am trying to create a line chart with 3 data categories. The issue that I am having is that one of the data cats. only has part of the columns populated with data. I believe this is affecting how the auto Axis is calculating the min value (0). I would like to know if there is a work around, or something I can put in the blank cells so that the Auto Axis Min is calculated off the actual lowest inputed value and not the blank cell. I have attached a rough example of that I am talking about. Also, I do need the Auto Axis to remain on as I some data validation lists that change the data that is pulled into the chart, so fixed axis is not an option.

Thank you in advanced!

**NickyC** · 11-14-2012, 09:15 PM

Hi
I don't think the problem is with your blank cells, as charting only the series with values in every cell gives you a 0 minimum when the axis is auto

**NickyC** · 11-14-2012, 10:12 PM

... Jon Peltier's excellent website has an explanation of how Excel determines minimum and maximum values for autoscaled axes:

http://peltiertech.com/WordPress/how...t-axis-limits/