Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
how to show date on the x axis of a line chart? | Charts and Charting in Excel | |||
Show quarters and years on x axis of a chart | Charts and Charting in Excel | |||
Show two value ranges on one axis | Charts and Charting in Excel |