100% Stacked Bar
 

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.

100% Stacked Bar
 

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.


"BoRed79" wrote:

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.

100% Stacked Bar
 

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.
--
Cheers,
Shane Devenshire


"BoRed79" wrote:

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.


"BoRed79" wrote:

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.