Stacked Bar chart - percentage share of a bar info

  • Thread starter Thread starter Marcin_Fuko
  • Start date Start date
M

Marcin_Fuko

I need to present a portfolio of loans on a bar chart for 4 end of months
split into currencies (there 3 currencies). I created a stacked bar chart (a
single bar is split into 3 colors, each representing a different currency).
Each bar has a value label. But I also need to include the label showing the
percentage share of each currency in the total portfolio. How can I achieve
this?
 
Hi,

Start by calculating the % Share in the spreadsheet. Say in column D.
In column E create a concatenated formula such as =C1&" - "&D1 where C1
contains the value label you mentioned.

Download & install the free XL Chart Labeler from
http://www.appspro.com/Utilities/ChartLabeler.htm

Select your series on the chart and run the Chart Labeler, indicate the
range for the labels is E1:E12 or whatever.

You can manually do what you want but you will need to do it for each point
on at a time.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
Back
Top