View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Wendymel Wendymel is offline
external usenet poster
 
Posts: 1
Default 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