Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the worksheet, set up custom labels that show what you want, with value
and percentage together in the cell. For example, if the data is in B2:B5, the label for B2 goes into C2, and uses a formula like this: =TEXT(B2,"0.0")&" ("&TEXT(B2/SUM(B$2:B$5),"0%")&")" which will give a label like 12.5 (18%) Fill this formula down to C5. Now use one of these free labeling tools to apply the labels in C2:C5 to the data points: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "cardan" wrote in message oups.com... Hello all, I have a question, which I thought was simple. I have a bar graph chart where the values are stacked on top of one another. (series is rows). I have place the values of each bar within the bars but would also like to show the percentages along side (or within) the bars. Is this possilbe? I can add another bar and show the percentages but this would not be very presentable. Any suggestions? Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding line chart w/ 2nd axis to stacked bar chart | Charts and Charting in Excel | |||
adding percentages to stacked bar charts | Charts and Charting in Excel | |||
stacked bar chart with percentages | Charts and Charting in Excel | |||
Helped with stacked bar chart and percentages | Charts and Charting in Excel | |||
Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel |