The x-axis is defined as "Time-scale". (On the Axes tab of the Chart Options
dialog box) Moreover, I can see the plotted points, and they are correct
(lots in the winter, few in the summer).

My problem is the labeling of the x-axis. It's all a smudge, as every point
has a label. That means I have 50 dates printed in a space of 5-6 inches on
my monitor. The dates are all printed on top of each other.

"HS Hartkamp" wrote in message
...

Are you sure the x-axis is defined as a proper linear scale ? (i.e.
xy-scatter plot) If not, excel treats the x-data as meaningless items.

Bas Hartkamp

"Bob Richardson" <bobr at whidbey dot com wrote in message
...
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.