View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Leo Bueno Leo Bueno is offline
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