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/...nkToSheet.html

Cheers
Andy

Dave wrote:
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



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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