- Apr 10, 2021
- Office Version
I have an Excel Line Chart. The minimum value within my range of data is 250,000, but while the Y axis is set on automatic, it still shows all the way down to zero. For a bar chart, when you're comparing the height of the bars against each other, yes, you need to see the entire length of each bar from zero, but with a line chart, you don't need to see the empty space between zero and the smallest value of your data. What's important in a line chart is to see the difference within the range of the data. I'm an old LOTUS 1-2-3 user, and this was automatic for a line graph.