You need to construct your labels in another worksheet range. For the
January Series 1 label it would look like
=B2&" ("&TEXT(B2/SUM(B2:B3),"0%))&")"
Then use one of these free Excel add-ins to apply the labels from the
worksheet range to the data series in the chart:
Rob Bovey's Chart Labeler,
http://appspro.com
John Walkenbach's Chart Tools,
http://j-walk.com/ss
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
774-275-0064
208-485-0691 fax
http://PeltierTech.com/
_______
PK wrote:
I thought this would be easy, but I am really stumped!
I need to show the percentage in addition to the value in the data labels
for a line chart.
Example,
January February
Series 1 5 6
Series 2 15 4
I would like the January data label for Series 1 to show 5 (25%)
I would like the January data label for Series 2 to show 15 (75%)
I would like the February data label for Series 1 to show 6 (60%)
I would like the February data label for Series 2 to show 4 (40%)
TIA FOR ANY HELP!