ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Percent Data Label on 100% Stacked Column Chart (https://www.excelbanter.com/charts-charting-excel/29532-percent-data-label-100%25-stacked-column-chart.html)

PNichols

Percent Data Label on 100% Stacked Column Chart
 
I've created a chart with three 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!

Barb R.

You may want to try Rob Bovey's XY Chart Labeler add in.

http://www.appspro.com/Utilities/ChartLabeler.htm

"PNichols" wrote:

I've created a chart with three 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!


PNichols

Thanks, that was very helpful.

"Barb R." wrote:

You may want to try Rob Bovey's XY Chart Labeler add in.

http://www.appspro.com/Utilities/ChartLabeler.htm

"PNichols" wrote:

I've created a chart with three 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!



All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com