We help IT Professionals succeed at work.

make a bar chart based on this excel sheet

al4629740
al4629740 asked
on
I have an excel sheet and would like to make a bar chart based on the age ranges and based on the groups in this sheet.  Any ideas of how I can have each bar represent a group on the far left column and then it would show the totals based on the far right column?
Book1.xlsx
Comment
Watch Question

How is this?
Book1.xlsx

Author

Commented:
Thats the idea.  How can I do that?
If you highlight the entire block of data and click Insert --> Chart and select "Stacked Column" as the chart type, it will automatically parcel everything out.  If you need to edit it once the chart is created, right click on it and click "Select Data" to change around what data the chart is looking at.