Bar Chart Series Issues

Hi all,

I have a bar chart with three series plotted against dates. The horizontal (date) axis is dynamic and so are the series, all of which use named ranges. The named ranges are working just fine, but there's a quirk about my chart that I can't figure out. With filter showing all three series together, the first one, Westpac Choice (red), won't show past the first two data points (note that its first data point is 01/02/2021, which is after the start of the other two series). The filter of Westpac Choice with either of the other two series also produces the same result. However, when filter shows Westpac Choice only, all the data points are showing as they should. I need to be able to filter and show all three series to compare them. It's such an annoying little problem. I can't upload a copy of the workbook because it contains sensitive information, so I hope the screenshots will suffice to at least explain the issue. If a dummy workbook would make it easier to understand, please let me know. Thanks in advance for your help.

Kind regards,

Liam