6 Replies Latest reply on Oct 22, 2012 10:53 AM by Justin Smith

# Simple (for someone else) percent tool tip

What I have is a bar chart showing the number of students of various race both male and female and a column for the total of the number of males and females (Attached.) Everything looks how I would like it, except I would like to be able to display for each bar a % of the total number of students (all male plus all female) in the tool tip, and hopefully as a label. Any thoughts? I'm sure this is easy, but this beginner can't figure it out! Any help and step by step is greatly appreciated!

Justin

• ###### 1. Re: Simple (for someone else) percent tool tip

Attached.

• ###### 2. Re: Simple (for someone else) percent tool tip

Alex,

Thanks for your reply. I was able to get the label to display the same percentages your correction shows, but it is race as a percent of total. What I'm looking for is what percent each bar represents. For example, there are 1,376 white male students. The tooltip (and hopefully label) for that bar would show 36% (1,376 white males / 3,820 total students). For white female students, it would show 28% (1,059 / 3,820). So then, the percentages for the races would total to 100% (roughly might have rounding issues), and the grand total bars would display what percent of all students are male and female (58% and 42% respectively)

Thoughts?

Justin

• ###### 3. Re: Simple (for someone else) percent tool tip

Got you. Attached - we needed sep % for each ***. There is a caveat that both appear on both tooltips unless we use a dual axis and multiple mark types.

• ###### 4. Re: Simple (for someone else) percent tool tip

Alex,

Thanks so much. I like exactly how it is, except I would prefer it to only have the male percent when on a male bar, and female on female. I assume this is what meant when you mentioned using dual axis and multiple mark types. Is this something that can be done? Sorry, I know you have been more than helpful - just can't seem to get this figured out!

Justin

• ###### 5. Re: Simple (for someone else) percent tool tip

See sheet 2 on this one.

• ###### 6. Re: Simple (for someone else) percent tool tip

Got it! Thanks again Alex.

Justin