Have you tried using a dual axis chart? Dual Axes
If that does not resolve the issue, could you attach a sample workbook demonstrating the issue?
It is much easier for the community to help out when we can play around with the data.
Thanks, dual axis worked then got stuck as couldn't synchronise the axis scale which I think is something to do with floating values. Think have resolved this issue now also.
Yes I know easier to attach workbook but not worked out how to do that yet with a subset of data in it as we have a massive database/records.
Have managed to extract the data and attach the workbook. Really struggling to get the blending to work as I can get the 2 graphs to show but then not the future forecast beyond current YTD as there is no actual data to blend on then. Thought if i just created a calc field for month I could blend on this but then came up against a whole set of other problems.
Any help appreciated.
Export.twbx 3.6 MB