Barchart 'GroupBy' Question

[bobschroeder]

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

 

[Jon Peltier]

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/
_______