Chart display help

[Rusty McLouth]

How can I have the chart bars display the percentages and the data labels be
the raw numbers? Is this possible?

 

[Shane Devenshire]

Hi,

By default bar charts don't display percentages, however, you could create
custom data labels by combing a calculation of the percentage with the actual
value in another range and the using a program like the free XL Chart Labeler
to pick up that range for the data labels.

http://www.appspro.com/Utilities/ChartLabeler.htm

Suppose the numbers that are your Values are in C2:C10, create a new column
by entering the following formula in D2
=C2/SUM(C$2:C$10)
Copy this formula down to row 10. This calculates the %'s
In E2 enter the formula
=C2&" - "&D2
Copy this formula down. It concatenates the value and the %. You may need
to modify it as follows:
=C2&" - "&TEXT(D2,"0%")
or some other format.

Now use the Chart Labeler to use the entries in E2:E10 as the chart's data
labels.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

 

[Adam_needs_help]

SO, Excel cannot do this without an add on?

Hi,

By default bar charts don't display percentages, however, you could create
custom data labels by combing a calculation of the percentage with the actual
value in another range and the using a program like the free XL Chart Labeler
to pick up that range for the data labels.

http://www.appspro.com/Utilities/ChartLabeler.htm

Suppose the numbers that are your Values are in C2:C10, create a new column
by entering the following formula in D2
=C2/SUM(C$2:C$10)
Copy this formula down to row 10. This calculates the %'s
In E2 enter the formula
=C2&" - "&D2
Copy this formula down. It concatenates the value and the %. You may need
to modify it as follows:
=C2&" - "&TEXT(D2,"0%")
or some other format.

Now use the Chart Labeler to use the entries in E2:E10 as the chart's data
labels.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire