Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Charting Multiple Series?
Hi,
I have attached a png file of my data that I need to chart. There are 5 data series (4 event types each with an associated qty and 1 inventory balance quantity). Is there a way to graph this so I have 5 graph lines over the date range? TIA, Dan |
#2
|
|||
|
|||
You could create a pivot table to summarize the data, and create a chart
from the pivot table results. There are instructions for pivot tables in Excel's Help, and Jon Peltier has information and links: http://peltiertech.com/Excel/Pivots/pivotstart.htm Dan wrote: I have attached a png file of my data that I need to chart. There are 5 data series (4 event types each with an associated qty and 1 inventory balance quantity). Is there a way to graph this so I have 5 graph lines over the date range? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
CHARTING W/INDIRECT SERIES | Charts and Charting in Excel | |||
How can I plot a data series from multiple worksheets | Charts and Charting in Excel | |||
How can I plot a data series from multiple worksheets | Charts and Charting in Excel | |||
Multiple rows of data on a single axis (charting) | Charts and Charting in Excel |