Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up annual "tick" marks on the horizontal axis?
I am trying to format the tick marks on the horizontal axis as years, e.g.,
2000, 2001, 2002 etc. This should be easy but none of the "canned" formats let me do this. All suggestions will be greatly appreciated. Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up annual "tick" marks on the horizontal axis?
Hi,
The number format would be YYYY assuming your source for the axis are date values. If the scale is a Time series scale you can also set the Major value to 1 and unit of Years. If you need more help can you provide information on xl version, chart type, axis type, data source for axis. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Dave in Cumming" <Dave in wrote in message ... I am trying to format the tick marks on the horizontal axis as years, e.g., 2000, 2001, 2002 etc. This should be easy but none of the "canned" formats let me do this. All suggestions will be greatly appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tick Marks On Axis: How, Please ? | New Users to Excel | |||
bar chart prints 1 unwanted horizontal row of dots & tick marks? | Charts and Charting in Excel | |||
Y-axis tick marks | Charts and Charting in Excel | |||
x axis tick marks | Charts and Charting in Excel | |||
cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) |