R
Rusty McLouth
How can I have the chart bars display the percentages and the data labels be
the raw numbers? Is this possible?
the raw numbers? Is this possible?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
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
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
A
Adam_needs_help
SO, Excel cannot do this without an add on?
Shane Devenshire said: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