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

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