100% Stacked Bar

G

Guest

Dear All.

I have produced a series of 100% Stacked Bar charts. The charts show the
percentage of people giving ratings of very poor, poor, average, good and
very good.

I would like to add onto the charts a line which shows where above average
ratings are for each of the categories, so that they can be compared 'at a
glance.'

Is there a way that this can be done.

Happy to provide more information if needed.

Thanks.
 
G

Guest

By the way - I do not really just want to draw one on, as I would like it to
be linked to the data (as I am going to be producing a lot of them).

Thanks.
 
G

Guest

Hi,

If you want lines for the averages of each group create one new series for
each average - all the values will be equal in any one group. Add the new
series to your chart and then select each one and change its chart type to
line.
 

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 charts 1
Balance Points in Excel Charts 1
Create Stacked column of multiple values across categories 3
Negative Values in Stacked Bar Charts 3
Stacked bar charts of plan versus actual 1
how do I create a double stacked bar chart? 3
Stacked column with additional single bar chart 2
How to create a stacked bar, line combination chart 2

Top