#1
|
|||
|
|||
Trying to DO Auto Update 12 Month Rolling Chart
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 Last edited by GraemeSS; 04-06-2020 at 07:29 PM. Reason: Added my name and the link |
#2
|
|||
|
|||
Phew, it has now shown up.
Last edited by GraemeSS; 04-06-2020 at 07:30 PM. Reason: No longer relevent |
#3
|
||||
|
||||
Charts sheet, cell B41:
=MATCH(B42,DataSum!$5:$5,0)-2 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can we update Chart in PPT based on a table in the excel and the table is part of the Chart Data | nareshj | PowerPoint | 0 | 07-12-2018 02:29 PM |
Column chart, comparing shift production by day, week, month | rossmoyne | Excel | 1 | 02-27-2017 10:27 AM |
Auto update excel graph range, ignore data when date reads 00-Month-00 | SavGDK | Excel | 2 | 06-24-2016 08:05 AM |
Bar Chart issue when Month Name Changes on Axis | randolphoralph | Excel | 4 | 05-13-2016 05:08 AM |
Update a summary chart when I update a dashboard with dates | cangelis | Excel | 6 | 09-24-2014 08:08 AM |