LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
plum
 
Posts: n/a
Default Horiz axis major ticks show [1913, 1923, 1933, ...]

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
X axis major ticks show [1913, 1923, 1933, ...] plum Charts and Charting in Excel 0 May 19th 06 01:15 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
how to show date on the x axis of a line chart? Ginger Charts and Charting in Excel 4 May 1st 05 02:11 AM
Show quarters and years on x axis of a chart Kacee Charts and Charting in Excel 3 March 19th 05 03:42 AM
Show two value ranges on one axis NOKIA Charts and Charting in Excel 5 December 23rd 04 01:51 PM


All times are GMT +1. The time now is 03:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"