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

  • Thread starter Thread starter plum
  • Start date Start date
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
 
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.
 
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?
 
Back
Top