Chart With Multiple Values

[cqweb]

Hi

I'm fairly new to this. I have a problem in that I have a set of data that I need to represent graphically.

The data is something like this:

Sale Date
Scheme Source Sales
1/8/10 MyScheme Somewhere 3
1/8/10 MyScheme Someone 5
1/8/10 TheirScheme Someone 1
2/8/10 OurScheme OrOther 2
2/8/10 MyScheme OrOther 7
2/8/10 MyScheme Someone 4
2/8/10 MyScheme Somewhere 3
2/8/10 TheirScheme OrOther 2
2/8/10 TheirScheme Somewhere 2
3/8/10 TheirScheme OrOther 1
3/8/10 OurScheme SomewhereElse 1
3/8/10 TheirScheme SomewhereElse 2
3/8/10 MyScheme Nowhere 1
3/8/10 MyScheme Somewhere 5
3/8/10 MyScheme Someone 12
3/8/10 MyScheme OrOther 5
3/8/10 TheirScheme Someone 1


I need to show that on 01/08/2010 3 sales of MyScheme came from Somewhere and 5 came from Someone, whereas 1 sale of TheirScheme came from Someone.

I'm struggling to figure out how to represent this using and Excel chart and some pointers would be gratefully received.


Cheers


CQW

[Andy Pope]

Sheet1 is how the data would need to be prepared in order to chart.

Sheet4 is a pivot table/chart

[cqweb]

Thanks for that

A pivot chart did the trick.

Thanks again


CQW