Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
plum
 
Posts: n/a
Default X 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

Reply
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
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
Secondary Axis Match Primary Axis Gridlines [email protected] Charts and Charting in Excel 1 July 31st 05 09:23 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 10:20 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"