creating bar charts from excel spreadsheet

lee53
lee53 used Ask the Experts™
on
need to show a bar chart per 'system no' and 'person identified by' for 'status open and closed'. can you help
ABS-Master-Deviation-Tracker-6.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Look at sheet 2. You can move fields from Values to Rows if it is not as expected
ABS-Master-Deviation-Tracker-7.xlsx

Author

Commented:
Thanks, that has really helped. I still don't know how you did it, could you send me on a link as to how this is done
1. Select your data (I've unmerged cells with names before)
2. Select "Inservt" tab in ribbon
3. Press "PivotChart" on ribbon and confirm selection
4. Mark nesessary fields in "Pivot Chart fields" (as they are marked in my sample)
5. Move "System no" fieldto values area

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial