Thread: Adding % values to a bar chart

Hi

I like to think I am fairly good with excel but I need some help in understanding how to add % values to a bar chart that has absolute values (as opposed to %'s) on the y-axis.

All I am trying to do is graph a bar chart with absolutes on the y-axis, elect to display values, and have the values show as %'s on the bars, but this seems impossible and the only way to do it is overtype the values with the right % amounts (which is not very helpful if the numbers change later)!

Any help gratefully appreciated.

Thanks

A couple of ideas. In both cases, I would have a column in the worksheet calculate the percentages for you (if you haven't already).

1) And I think this is the easiest, though it doesn't give you exactly what you've requested. Take the percentages in the worksheet and add them as a second series. Format that second series so it plots on the secondary axis and so it is effectively hidden. Then format the secondary axis so its range matches up to the equivalent values on the primary axis.

2) Write a VBA sub procedure (possibly associeated with the calculate event). The basic idea is to retrieve the percentages calculated in the worksheet and apply them to each DataLabel object in the DataLabels collection (see VBA help for DataLabel object and collection and for the Text property as it applies to the DataLabel object). How difficult this option is depends on how skilled you are with VBA.