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

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