100% Stacked Bar Problem

[rubix]

I'm having a problem with how the data is represented in one instance using 100% stacked bars. In the file attached the 'barometers' on the right represent the data in the G and R columns. Where G = 6 and R = 1 the chart does not display correctly - there is too much red. The data in G and R are countifs of other columns in the table. Does anyone have an idea of why the chart does display correctly when the data is 6 and 1?

Thanks

[Andy Pope]

without seeing the actual chart and data it's hard to say what your problem is.

[rubix]

without seeing the actual chart and data it's hard to say what your problem is.

Here is a file containing the problem - see chart # 1.

As there are 6 green and only 1 red I want it to display more green than charts 2 - 6.

[Andy Pope]

Check what excel has decided to use as the default min/max values for the axis.

In order to keep the charts consistent you will need to force the values of min/max to 0 and 1.

[rubix]

Check what excel has decided to use as the default min/max values for the axis.

In order to keep the charts consistent you will need to force the values of min/max to 0 and 1.

That works. Thanks for your help.