Charting Series Problem

I am in need of changing the Axes Scale on my spreadsheet
from 0 to 500 to 100 to 900 but in 100 increments. I
tried to format the Axis this way but then my data on the
chart disappears. When I check the boxes back to
automatic, then my data appears.

Any help is greatly appreciated. I believe I am using
the Office 2000 product.

Thanks

What kind of chart do you have? What is the range of the data set you
are plotting? How many are in the range of 0-100 and 500-900?

You don't have to guess about the version of XL. Check Help | About
Microsoft Excel

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <08be01c3b06a$05cd04d0$a001280a@phx.gbl>,
anonymous@discussions.microsoft.com says...
> I am in need of changing the Axes Scale on my spreadsheet
> from 0 to 500 to 100 to 900 but in 100 increments. I
> tried to format the Axis this way but then my data on the
> chart disappears. When I check the boxes back to
> automatic, then my data appears.
>
> Any help is greatly appreciated. I believe I am using
> the Office 2000 product.
>
> Thanks
>