Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
create line graph with 3 variables? | Excel Discussion (Misc queries) | |||
Create a line graph of quanitity of values | Charts and Charting in Excel | |||
How do you create a cumulative line graph? | Excel Discussion (Misc queries) | |||
How do I create a line graph with x- y axis? | Charts and Charting in Excel |