Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart display help
How can I have the chart bars display the percentages and the data labels be
the raw numbers? Is this possible? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I display an Excel chart as my screensaver display? | Charts and Charting in Excel | |||
Dynamic Chart Display | Charts and Charting in Excel | |||
How to display a series in chart table and not in the chart? | Charts and Charting in Excel | |||
How to display the negative bar in bar chart? | Charts and Charting in Excel | |||
Pie Chart display | Excel Discussion (Misc queries) |