Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Line Graphs
Hello
I am trying to create some graphs (bar or line). I have 2 columns of data, with 20 rows. I have names on one columns, and time spent on 2 column. The names appear multiple times, so I was the graph to sum the hours in cases where the names appear multiple times. -- Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Line Graphs
Make sure you have labels above each column, like Name and Time. Select
the data and make a pivot table. Drag the Name field to the rows area and the Time field to the data area. If necessary change the Time to Sum of Time (sometimes Excel guesses wrong). This lists each name only once, alongside the sum for that name. Now make your chart. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ user wrote: Hello I am trying to create some graphs (bar or line). I have 2 columns of data, with 20 rows. I have names on one columns, and time spent on 2 column. The names appear multiple times, so I was the graph to sum the hours in cases where the names appear multiple times. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line graphs | Charts and Charting in Excel | |||
Line graphs | Charts and Charting in Excel | |||
Line Graphs? | Excel Discussion (Misc queries) | |||
How do you select line or columns in "Line-Column on 2 axes" graphs? | Excel Discussion (Misc queries) | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) |