LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default Can't figure out Simple Percent Label

I would like the column chart to show the percent as the value label.

For example

East 2
West 4
North 10
South 4

In the chart, I want the y-scale to be 0 to 10 (or 12), but the values on
the data labels to be:
East 10%
West 20%
North 50%
South 20%

I have tried putting the % in a separate column but of course that shows up
as a different series.

Seems like it should be so simple, but I can't get it to do it. What am I
missing, please.

tia for any suggestions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
data labels to show value, label & percent nihad Charts and Charting in Excel 1 January 16th 06 08:39 PM
Show data used and percent label Desiree Charts and Charting in Excel 2 October 18th 05 04:34 PM
how do i figure percent martha Excel Discussion (Misc queries) 1 October 11th 05 04:19 PM
Percent Data Label on 100% Stacked Column Chart PNichols Charts and Charting in Excel 2 June 13th 05 01:56 PM
Is there a way to have two values (percent and number) in a label. msmiller613 Charts and Charting in Excel 1 December 15th 04 03:47 AM


All times are GMT +1. The time now is 03:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"