Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Auto Scale x-axis
Use a column to combine your first two columns to generate an x-axis
containing both month and year, either as a real Excel date or as text. -- David Biddulph "Mykonos" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Auto Scale x-axis
Hi,
If there are just 12 months in each year then this will happen automatically. Select all the data and choose Insert, Chart, click Next, click the Series tab. Select Series1 and Remove it, select Series2 and remove it. Click in the Category (X) axis labels box and enter =Sheet1!$A$1:$B$24 (or highlight the first two columns of the spreadsheet data. Click Finish. If this helps, please click the Yes button Cheers, Shane Devenshire "Mykonos" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Y-Axis Auto-Scale Min Erroneously Set At Zero | Charts and Charting in Excel | |||
Auto Update of Y axis Max, Min and Scale | Charts and Charting in Excel | |||
Y Axis Auto updatem Max, Min and Scale | Excel Discussion (Misc queries) | |||
Y Axis Auto Scale | Charts and Charting in Excel | |||
Auto Y-Axis Scale | Charts and Charting in Excel |