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

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