Chart display help
 

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

Chart display help
 

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

"Rusty McLouth" wrote:

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

Chart display help
 

SO, Excel cannot do this without an add on?

"Shane Devenshire" wrote:

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

"Rusty McLouth" wrote:

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