Thank you Jon - that did it. My biggest problem was rechecking the auto
boxes. It wasn't clear to me that they should remain unchecked.
"Jon Peltier" wrote in message
...
Bob -
Keep the Axis as a time scale category axis, don't change to an XY Scatter
chart.
Keep the Base Unit on the X Axis Scale dialog in Days, but change the
Major Unit to 1 Year, and the Minor Unit to something like 3 Months. Make
sure the boxes ('Auto') in front of these options remain unchecked.
This should neaten up your axis.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Bob Richardson wrote:
I have 5 years worth of data (price vs. date). It is graphed correctly on
a time-scale. The problem is the x-axis labels. There are so many it's
just a blur of black smudgy ink below the x-axis. When I made the Base
Unit "months", Major unit 12 months and minor unit one month, no change
occurred, and the choices I made reverted back to the default? Days, 7,
1.
What I want is a tick mark on the x-axis every month, with a label every
January; e.g. Jan-01.....Jan-02....etc.