Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default How do I plot multiple series on one graph? - test-graph.xls (0/1)

Having a hard time with the Excel 2003 Wizard plotting the data listed
below (file attached).

I would like the X axis to be the year (1999, 2000, etc.) and the Y
axis to show the value for each series of the "Variable".

Also, would like a legend to each series indicating the city.

The idea is to see the values for each city as a function of time.

Thanks in advance.


Variable

1999 2000 2001 2002 2003
Miami-Dade 0.087 0.059 0.065 0.000 0.018
Atlanta 0.111 0.126 0.048 0.025 0.071
Chicago 0.087 0.113 0.042 -1.336 -0.015
Broward 0.070 0.061 0.054 0.036 0.029
Los Angeles 0.114 0.093 0.048 0.049 0.051
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default How do I plot multiple series on one graph? - test-graph.xls (0/1)

Hi,

If you clear the cell A3 of the single quote the wizard will make more sense
of your data.
Currently the row 3 is being treated as data rather than labels. So you get
a cluster of columns with values of 1999 to 2003 for the first category and
all the others are less than 1 which means they do not appear as their
values are so small.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Leo Bueno" wrote in message
...
Having a hard time with the Excel 2003 Wizard plotting the data listed
below (file attached).

I would like the X axis to be the year (1999, 2000, etc.) and the Y
axis to show the value for each series of the "Variable".

Also, would like a legend to each series indicating the city.

The idea is to see the values for each city as a function of time.

Thanks in advance.


Variable

1999 2000 2001 2002 2003
Miami-Dade 0.087 0.059 0.065 0.000 0.018
Atlanta 0.111 0.126 0.048 0.025 0.071
Chicago 0.087 0.113 0.042 -1.336 -0.015
Broward 0.070 0.061 0.054 0.036 0.029
Los Angeles 0.114 0.093 0.048 0.049 0.051


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
plot graph from multiple worksheet as embedded chart object on every worksheet [email protected] Excel Discussion (Misc queries) 2 August 24th 06 05:26 PM
plot graph from multiple worksheet as embedded chart object on every worksheet [email protected] Excel Worksheet Functions 2 August 24th 06 05:26 PM
plot graph from multiple worksheet as embedded chart object on every worksheet jeftiong New Users to Excel 0 August 23rd 06 01:50 PM
plot 4 time series in a common graph Moohwan Excel Discussion (Misc queries) 2 April 29th 06 04:05 AM
How do you set all graph data points to black (multiple series)? DamnKiwi Charts and Charting in Excel 1 September 1st 05 01:00 PM


All times are GMT +1. The time now is 08:41 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"