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