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.

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.

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.