problem to create a line graph
 

I have table with date, name of cities, temperature of citeis for each day
in canada
as columns, What i want to create is to have line graph for each cities in
different color to see
temperature change in a whole year, but I don't know how to extract a
specified
cities' temperature in a day

Thanks in advance
Shinya

problem to create a line graph
 

Shinya -

Use the data to construct a pivot table (Data menu). Put the cities into
the column area, the dates into the row area, and the temperatures into
the data area.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


sk wrote:

I have table with date, name of cities, temperature of citeis for each day
in canada
as columns, What i want to create is to have line graph for each cities in
different color to see
temperature change in a whole year, but I don't know how to extract a
specified
cities' temperature in a day

Thanks in advance
Shinya