problem with x-axis scales

G

Guest

I am trying to create an x-axis with a major unit of 14
days that runs from 1/11 as the minimum to 12/31 as the
maximum. Every time I enter this information in
the "Format Axis" box and click ok, the axis automatically
goes back to having a major unit of 7 days, with the
minimum as 1/11 and the maximum as 5/2. When I go back
and open up the "Format Axis" box, it's as if I never
entered the information I wanted. I have four small line
charts embedded on one page, so space is limited. Maybe
that's the problem. I have no idea and welcome any advice
you may have.
 
J

Jon Peltier

After you change the parameters, do you keep the Auto boxes unchecked?
Checking the boxes tells Excel to do whatever it wants with your axes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

Top