Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
x axis custom scale
I have a chart representing the following data:
1/17/09 $5,123.00 2/2/09 $125.00 3/30/09 $861.00 4/5/09 $3,325.00 5/15/09 $532.00 6/28/09 $147.00 7/4/09 $6,495.00 8/8/09 $456.00 9/18/09 $845.00 10/31/09 $947.00 11/25/09 $9,953.00 12/10/09 $125.00 My chart style is simply a line graph. The problem is that my x-axis is defaulting to the following: 1/17/09 3/17/09 5/17/09 7/17/09 9/17/09 11/17/09 I would like the ticks to be representative of the actual dates in the cells, exact monthly intervals. How can this be accomplished? Thanks, Wendy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
How do I reference x-axis or y-axis scale values to a worksheet ce | Excel Discussion (Misc queries) | |||
How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit | Charts and Charting in Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |