#1   Report Post  
Posted to microsoft.public.excel.charting
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.

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3,346
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Y-Axis Auto-Scale Min Erroneously Set At Zero mvagnier Charts and Charting in Excel 2 April 24th 07 03:44 PM
Auto Update of Y axis Max, Min and Scale Philip J Smith Charts and Charting in Excel 1 March 30th 07 12:34 PM
Y Axis Auto updatem Max, Min and Scale Philip J Smith Excel Discussion (Misc queries) 0 March 28th 07 12:00 PM
Y Axis Auto Scale Arturo Charts and Charting in Excel 1 March 27th 06 04:23 PM
Auto Y-Axis Scale systemx Charts and Charting in Excel 1 March 22nd 06 07:47 AM


All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"