Stacked Columns Chart with Percentage Labels

Missyd

New Member
Joined
Sep 20, 2005
Messages
4
I have a stacked columns chart where I'm trying to use data labels formatted as percentages of each column. The Data Labels tab in the Chart Options dialog shows that the percentage option is grayed out.

Does that mean that percentage labels aren't available for this specific type of chart? Is there a way to work around that or is there a different chart type I should be using to do what I'm trying to do here?

Thanks,
Missy
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Missy,

I don't know if this would work for you but you could create a calculated column for the percentages, and use this as the source data for the stacked column.
Alternatively, if you don't have too many data series, use a pie chart

Denis
 

Missyd

New Member
Joined
Sep 20, 2005
Messages
4
Denis,

Thanks for the reply. I'm actually trying to help someone else with this and he didn't want to use the calculated columns option. He thought it would get too complicated because the charts would be dynamic. He didn't want to use the pie charts or the 100% stacked column options because he would lose the relative reference among the columns.

Any other suggestions?

Thanks,
Missy
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
You could still use the percentage column with dynamic charts, but I guess it depends how many categories you are tracking. And yes, you would lose the relativity between datasets.
There are some serious charting gurus out there -- maybe their sites will give some clues. Try searching Google for Jon Peltier, Stephen Bullen or Tushar Mehta

Denis
 

Forum statistics

Threads
1,078,398
Messages
5,339,983
Members
399,345
Latest member
elvy

Some videos you may like

This Week's Hot Topics

Top