Grouping data query

  • Thread starter Thread starter Alex Schaft
  • Start date Start date
A

Alex Schaft

Hi,

I've got grouped sql sitting in an excel sheet as follows:

Cat Supplier Amount
A A 1
A B 12
A D 7
B B 23
B C 9
B E 30

I'm trying to create grouped bars on Category, with bars in the groups
representing the amounts per supplier. I've tried getting the Chart
wizard to do this to no avail, as each line becomes a bar Excel 2003.

What am I missing?

Thanks,
Alex
 
Back
Top