Gap appearing in stacked bar chart

[smckec]

Hi,

I'm using a stacked bar chart with multiple data series (each with one value) to display a colour-coded set of bars:



(note that this is just how the chart appears in the Designer; there will actually only be one value per series so only the top third of the chart above will appear in the final result)

This works great if each series exists in the data input; however we do have cases where one of the data series will not exist. In the final output, this appears as a gap in the bars:



Is there a way to close this gap between the bars if one of the series does not exist? We have experimented extensively with the chart settings and can't seem to find a way to achieve this!

Thanks in advance

Sam

[Lech Kulikowski]

Hello,

Unfortunately, there are no any options. Each series should present, empty also.

Thank you.