Grouping data query
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 |
Grouping data query
Hi Alex,
You want to look into PivotTables and PivotCharts for grouping. Microsoft.com and the internet have lots of info on PivotCharts. http://office.microsoft.com/en-us/ex...773841033.aspx -- Thanks, Christopher This posting is provided "AS IS" with no warranties, and confers no rights. "Alex Schaft" wrote: 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 |
All times are GMT +1. The time now is 06:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com