View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Mykonos Mykonos is offline
external usenet poster
 
Posts: 1
Default Auto Scale x-axis

e.g. The excel worksheet got 3 columns
Year Month (No. of cases happen in this month)
07 01 100
02 90
03 18
...
...
12 88
08 01 99
02 120

and plot a chart with the month/year as x-axis, the no. of case as the Y-axis.

How to auto scale x-axis if it contains data for 5 or even 10 years ?

Thank you.