• 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.

Data labels Percentage together

P

PSG

Member
Hi All,


I would like to know is it possible to have data labels & their repective percentage together in column or bar chart.


For example 5,10,15 & 20 is my series. I want to show my data label as 5 (10%), 10 (20%), 15 (30%) & 20 (40%) respectively.


Thanks in advance for looking into this!
 
You can show whatever you want in the data label. The trick is generating the information. =)


For your case, next to your data, you'll need some helper cells with formula similar to:

=SeriesName & " (" & TEXT(SeriesValue/TotalValueOfAllSeries,"##%") & ")"

Once you've got all those cells setup, we simply need to link them to the chart.

Referencing the one of Jon Peltier's articles (http://peltiertech.com/WordPress/link-chart-text-to-a-cell/), about half way down you'll see a note about linking data labels and some free add-in's, which I recommend.


Either way, you'll want to add some data labels (pick anything to start), and then link the data label to the cell.
 
You guys Luke, Hui & our Chandoo are real champ!


I knew I would have never got the solution so fast else where.


Thanks for making us awesome guys!!!
 
You must log in or register to reply here.
Back
Top