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)