Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Dates in Graph Scale
I need to create a graph with Dates on the X axis as follows:
2/7/08 3/31/08 6/30/08 9/30/08 12/31/08 I can get dates for 12/31/07, 3/31/08, 6/30/08, 9/30/08, 12/31/08 to show if I select 3 months as the scale on the X-axis, but I don't want 12/31/07 -- I want 2/7/08 as my beginning date. How do I show 2/7/08 and then the remaining quarter-ending dates? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Dates in Graph Scale
Excel doesn't provide that fine control over axis scales. Me, I'd just keep
12/31/07, but I suppose you could make a dummy axis and add data labels to show the desired dates: http://peltiertech.com/Excel/Charts/...tml#AxisScales - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "CParker" wrote in message ... I need to create a graph with Dates on the X axis as follows: 2/7/08 3/31/08 6/30/08 9/30/08 12/31/08 I can get dates for 12/31/07, 3/31/08, 6/30/08, 9/30/08, 12/31/08 to show if I select 3 months as the scale on the X-axis, but I don't want 12/31/07 -- I want 2/7/08 as my beginning date. How do I show 2/7/08 and then the remaining quarter-ending dates? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scale on line graph | Charts and Charting in Excel | |||
changing the scale on the graph | Charts and Charting in Excel | |||
Radar Chart with Variable X Scale | Charts and Charting in Excel | |||
Graph on Inverted Scale | Charts and Charting in Excel | |||
Setting x axis scale to time with variable intervals | Charts and Charting in Excel |