View Single Post
  #2   Report Post  
HS Hartkamp
 
Posts: n/a
Default


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.