+ Reply to Thread
Results 1 to 2 of 2

Multiple Categories with several legends in one chart (and 'n' vs % question)

  1. #1
    Registered User
    Join Date
    04-05-2013
    Location
    Bay Area, CA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Multiple Categories with several legends in one chart (and 'n' vs % question)

    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.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Multiple Categories with several legends in one chart (and 'n' vs % question)

    Maybe you could use the multi level category approach.
    Data labels are linked to cells in order to display counts
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1