Bar Chart with Percentages Added

[Katherine]

Hi,

Is there any way to have a bar chart and then have percentages to the side
of each pair of bars? The first series of data I have is Sales and the
second series is A/R Collections. I want to have the percentage of A/R
Collections to Sales appear next to each pair of bars, but I notice this
option is greyed out on the chart options.

Thank you,
Katherine

[Jon Peltier]

Calculate the percentages in the worksheet, then use one of these two handy Excel
add-ins to apply the percentage labels to the series:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Katherine wrote:

> Hi,
>
> Is there any way to have a bar chart and then have percentages to the side
> of each pair of bars? The first series of data I have is Sales and the
> second series is A/R Collections. I want to have the percentage of A/R
> Collections to Sales appear next to each pair of bars, but I notice this
> option is greyed out on the chart options.
>
> Thank you,
> Katherine