Range for Y Axis

[Andy Pope]

Hi,

You can not automatically force the values.
You can however set them manually, double click y axis and enter max/min
values.

Or you can do it via code.
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

Cheers
Andy

 

[Dave]

I created a chart in Excel 2003.

The data source for the Y axis contains values from 3 to 8. However, Excel
draws the graph with Y values from 0 to 9.

I want my graph to be more compact, IOW I don't want a lot of unused space
(Y values 0-2) to display.

How can I force Excel to limit the Y axis display to values from 2 to 9?

Thanks
Dave