make a bar chart based on this excel sheet

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
al4629740Asked:
Who is Participating?
 
Katie PierceCommented:
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.
0
 
Katie PierceCommented:
How is this?
Book1.xlsx
0
 
al4629740Author Commented:
Thats the idea.  How can I do that?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.