Hi all, I'm not a beginner with excel, so I guess I'd call myself somewhere of a lower intermediate user. I've been trying to google this all over the place, but what seemed simple to me ended up being more complex via Excel than I thought:
This is what my graph looks like:
ijZ3B1ielsrTf.PNG
I've got the overall categories of Age, Race/Ethnicity, and Gender split into several bar graphs onto the same chart. Now I need three different legends to denote what each bar in those overall categories represent
Age (0-4, 5-9, 10-14, 20-14)
Race/Ethnicity (White, Black, Asian, Latino, Other)
Gender (Male Female)
But I just can't figure out how to format it or make the graph have those multiple legends (basically subcategories).
My other question is that currently the numbers are inputted as percentages. I want my graph to display the bars as percentages (Y Axis 1 to 100) but I want the absolutely numbers (n) to appear above each bar.
This got way more complex than I realized, but my boss really wants the graph to appear this way so I've got figure out how to work it.
Here is the sheet:
Example.xlsx
Thanks so much for anyone who can help me.
Bookmarks