Show Percent on Data Labels

[Paul Scheer]

In Excel 2000, I've created a non-stacked vertical bar
chart. I would like to show percent of total on the data
labels of each bar while retaining the actual data value
on the Y-axis scale. Can this be done? Under the Format
Data Series/Data Labels tab, the "Show percent" option is
grayed out.

Thanks for any assistance you can provide.

 

[Jean Ruch]

In Excel 2000, I've created a non-stacked vertical bar
chart. I would like to show percent of total on the data
labels of each bar while retaining the actual data value
on the Y-axis scale. Can this be done? Under the Format
Data Series/Data Labels tab, the "Show percent" option is
grayed out.

Thanks for any assistance you can provide.

Hi Paul,

you can possibly make use of one of these tools:

http://j-walk.com/ss JWalk Chart Tools
www.appspro.com Chart Labeler

regards,

Jean

 

[Paul Scheer]

Jean,

I tried XY Chart Labeler; worked like a charm. Thanks
very much for your reply.

Paul