Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Barchart 'GroupBy' Question
Is It possible to make a single bar chart look like:
http://www.808multimedia.com/bob/sample.jpg from workshhet data that looks like http://www.808multimedia.com/bob/sample2.jpg (sorry about the picture references...but eeasier than trying to describe it) Thanks In Advance..Bob |
#2
|
|||
|
|||
You can take your data and make pivot tables. Select the data, select Pivot Table
Report from the Data menu. When doing the layout of the table, put the CategoryItem field into the Page area, the ItemText field into the Rows area, and the Grade Score field into the Data area. Then select the appropriate category from the Page dropdown, and make your chart from the table that results. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: Is It possible to make a single bar chart look like: http://www.808multimedia.com/bob/sample.jpg from workshhet data that looks like http://www.808multimedia.com/bob/sample2.jpg (sorry about the picture references...but eeasier than trying to describe it) Thanks In Advance..Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
Data Table Question | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel |