| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Labels with Percentages
When I creata a bar chart, under data labels I am able to select value,
series name and category name. I'd like to have the value and the percentage, but percentage is greyed out. Is there a way to have both value and percentage displayed without resorting to a text box? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data Labels with Percentages
Build the labels you want in a range of cells, then use one of these free
utilities to apply the constructed labels to the series' data labels: 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 http://PeltierTech.com _______ "T-Dot" wrote in message ... When I creata a bar chart, under data labels I am able to select value, series name and category name. I'd like to have the value and the percentage, but percentage is greyed out. Is there a way to have both value and percentage displayed without resorting to a text box? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I generate and subtotal percentages of data in a pivot tabl | Excel Discussion (Misc queries) | |||
| I can't get the percentages to work in a bar chart data label. | Charts and Charting in Excel | |||
| How do I add percentages to data labels? | Charts and Charting in Excel | |||
| Figures in data box and percentages in graph | Charts and Charting in Excel | |||
| How do I set "y" axis to numbers and labels to percentages on my . | Charts and Charting in Excel | |||
Linear Mode
