• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using Data Labels from a Third Data Column in an Chart

E

Excel User

New Member
I am using Excel 2011 for Mac. I am making clustered column chart that compares the percentages of various categories. I would like each category to have a label that represents the absolute value of that category (So, if 10 cows represent 40% of the total, the cow category is represented graphically as 40%, but is also labeled with a number "10". I have three data columns: the category data column, the absolute value data column, and the corresponding percentage column. I know I can use the "Data Labels" option to display the data that is already represented in the chart (the percentage of each category). I also know that I can click on each data label and manually change it by typing in the text box, but this seems inefficient. How do I get Excel to use data that's in a third column for the data labels in a more efficient way?


Thanks for your help!
 
Excel User


Firstly, Welcome to the Chandoo.org Forums


I am unsure of what Excel 2011 for Mac offers


Excel 2013, allows you to select Data Labels locations from a Dialog box

Prior to that it had to be done either manually or via a Macro


To do it manually


Select a Series

Add a Data Label

Select the Data Labels

Then select an Individual Data Label

In the formula bar =$D$2 (Cell reference to your new labels)

Repeat for all Labels
 
You must log in or register to reply here.
Back
Top