stacked column chart but label with %?

W

Weissme

Hi again everyone,

I have a graph that has 5 variables in a stacked column. X axis is
year, Y axis is total number of people. On the same graph, I'd like to
label each individual series with its % of the total for that year.
I've done this before by making individual text boxes and manually
entering in the percentages, but I feel like there must be a better way
to do this. I tried a line-column graph and plotted the percentages on
a second Y axis (percentage) but the data points don't line up with
their corresponding bar chunk. I hope I'm making sense, I've b een
staring at this for quite awhile. Thanks!!
 
G

Guest

You might try using a PivotChart, instead of the normal chart tool. Pivot
tables have built in support for "% of total" so I assume pivot charts might
also have better support for that than the standard chart tool.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stacked Bar Chart 1
stacked column chart 5
stacked column graph adjacent to a regular column graph 0
How do I make a chart with bar graphs on one axis, and a line ona secondary axis? 2
display total in stacked column chart 3
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0
Excel 2003 - Combination chart: Stacked Column + Stacked Column 3
stacked column chart 4

Top