Horiz axis major ticks show [1913, 1923, 1933, ...]

P

plum

I'm using Office 2000 and have a problem labeling major ticks on the
horizontal axis (years).

My dataset starts on an "off" year, 1913 (i.e. not a turn-of-the-decade
like 1910 or 1960). I want to show labels only for decadal years.

However, I can't seem to get the major ticks to work; instead of 1910,
1920, 1930, ... it throws up 1913, 1923, 1933, ... It's not a
meaningless result, but it doesn't look good on the eye.

Am I missing some setting?

:plum
 
D

David Biddulph

plum said:
I'm using Office 2000 and have a problem labeling major ticks on the
horizontal axis (years).

My dataset starts on an "off" year, 1913 (i.e. not a turn-of-the-decade
like 1910 or 1960). I want to show labels only for decadal years.

However, I can't seem to get the major ticks to work; instead of 1910,
1920, 1930, ... it throws up 1913, 1923, 1933, ... It's not a
meaningless result, but it doesn't look good on the eye.

Am I missing some setting?
Click to expand...

What type of chart are you using? If XY (scatter), use Format Axis/ Scale,
& set the minimum to 1910.
 
P

plum

I'm using several different chart types, including line and
histographs. Setting the minimum to 1910 would exclude data points
before that year. Admittedly, there are only a few of them, but for the
sake of completeness, it would be preferable to include them.

I'm thinking this is a limitation of Excel 2000. Is there a plug-in
(add-in? add-on?) that I can download to correct this?
 
Top