Hi Good MS Office Forum gurus,




I posted previously in a few places and it was explained to me to make sure I reference cross posts. Sorry about that. Last time I got some really great responses here so I am not going to post elsewhere as yet. (Will add reference if I end up doing so).



I have attempted to build a sheet using the following tutorial. I have now got stuck and don't really know how to fix the problem. I am attempting to set up a chart on the Costs (A41 Charts tab).

Not Just Numbers: EXCEL TIP: Creating a rolling graph

I have most of it OK but the reference data is (B43-M43) is not referring/scaling to the correct months when I update the month in Charts M42. This is what I need help with. I hope to be able to figure the rest of it out once I get past this hurdle.



For context I am attempting to automate what I have done previously in the screen shot on the sample tab.


I am attaching a generic version of my sheet. All help would be gratefully accepted. Thanks, Graeme

Attached Files

Test Draft 1300 1800 Monthly Report 2020.xlsx (392.5 KB, 11 views)

Phew, it has now shown up.

Charts sheet, cell B41:
=MATCH(B42,DataSum!$5:$5,0)-2