Graphing multiple series over time

[Phil1234]

Hey,

Any idea how I can show the following in one chart (or any other better way?):

August 3rd:
sizes____apples________ oranges
1lb ________5 ___________8
2lb ________6___________ 9
3lb ________4___________ 6
4lb ________6___________ 9
etc.

August 4th:
sizes
1lb ________4 ___________26
2lb ________6___________ 9
3lb ________1___________ 11
4lb ________3___________ 12
etc.

But there would be more days, more sizes, and more types of series. (also, more sizes and series would be added/taken away over time.

I wouldn't mind having two x-variables (a range for all august 3rd, and in that range, chart all the sizes, then next to it, all august 4th and etc. in a scatter plot)

Any ideas/alternatives would be greatly appreciated. Thanks,

 

[Derek Brown]

Hello and welcome to The Board.
I don't use them myself (so I cannot give a specific example) but I think that you should use a bubble chart with a 'mini-chart' for each date(?).
A good source of help and examples for charts is:
http://peltiertech.com/Excel/Charts/