Charting Series Problem

E

Excelhelp

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
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Format numbers for learning chart 0
Chart SERIES OFFSET 5
Help with area under trendline 0
Using the full width of an Excel chart with two Y-axes 2
Dynamic series in rows 1
Employee Schedule not plotting properly - chart type / data series not correct 0
multi dimension/axis single series bar chart 0
Labeling on independently stacked line chart 0

Top