What is the best way to visually display this data set? (Advice)

Hi All,


I need some advice on the best way to present this set of data. I was asked to create a visually appealing and professional chart (less "cluttered") using the data included in the workbook. Specifically, I need to create a chart that shows the number of schools, classrooms, children, and capacity across various levels (1-5) that are receiving after-school services and compare it to my agency's entire network (what % is afterschool).

My first idea would be to create a chart which included stacked lines per category (example, a stacked line for Schools, Children, Classrooms, etc. separately) that is associated with each level and would have the % at the end of each line.

Example: example.PNG

But, I am having difficulties ensuring that each category is "stacked" separately. For instance, when I select "stacked" all of the categories are stacked in one line per level as oppose to 4 categories lines per level. Can someone show me how to perform this task? I have attached the workbook which includes several of my attempts.

Also, do you believe this is the best way to present the data in a more streamlined dynamic fashion? Any advice or suggestions would be greatly appreciated.

Thank you in advance.

Thank you for your suggestion. I am, however, having a difficult time following with Excel 2013. I am having this same issue with most of the tutorials found online (example: https://alesandrab.wordpress.com/201...arts-in-excel/ ).