View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 100% Stacked Column Chart Labels

Hi,

You can use this free add-in to link data label content to cells.
http://www.appspro.com/Utilities/ChartLabeler.htm

In those cells you calculate the value you need to display.

Cheers
Andy

jsv wrote:
I've created a chart with several 100% stacked columns, each having multiple
data points in common. I'd like to show what percentage each of the data
points is in relation to its column but the percentage data label is greyed
out. Is there another way to do what I'm trying?

Thanks!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info