Chart - Stacked Chart

[dunmore83]

Hi,

When creating a stacked chart with 2 series it is adding the data together. For example;

July 2017
- Series 1 = 202,412
- Series 2 = 335,943

This column is showing the sum of these two series which is 538,355

I need a stacked chart with the 2 series combined in 1 column but for it to simply show the maximum value not the sum of the 2 series. So in the above example for July the column would be 335,943

Any helpers ??

 

[Gerald Higgins]

So if you really want a stacked chart, then it sounds like you probably need another series to calculate the difference between 202,412 and 335,943, and then use THAT series in your chart, instead of your current series 2.

 

[dunmore83]

Thanks for you reply.

I am not sure this will work as the stacked column will show 335,943 as the total column & part of the column shaded as 133,531

I need the 1 stacked column to show 335,943 as the total & part of the column shaded as 202,412

 

[Gerald Higgins]

Sounds like potayto / potahto . . .

Play about with colours, and the sequencing of the 2 data series.