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

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
>