Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-06-2020, 07:20 PM
GraemeSS GraemeSS is offline Trying to DO Auto Update 12 Month Rolling Chart Windows 10 Trying to DO Auto Update 12 Month Rolling Chart Office 2019
Novice
Trying to DO Auto Update 12 Month Rolling Chart
 
Join Date: Apr 2020
Posts: 6
GraemeSS is on a distinguished road
Default 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
Attached Files
File Type: xlsx Test Draft 1300 1800 Monthly Report 2020.xlsx (392.5 KB, 9 views)

Last edited by GraemeSS; 04-06-2020 at 07:29 PM. Reason: Added my name and the link
Reply With Quote
  #2  
Old 04-06-2020, 07:24 PM
GraemeSS GraemeSS is offline Trying to DO Auto Update 12 Month Rolling Chart Windows 10 Trying to DO Auto Update 12 Month Rolling Chart Office 2019
Novice
Trying to DO Auto Update 12 Month Rolling Chart
 
Join Date: Apr 2020
Posts: 6
GraemeSS is on a distinguished road
Smile

Phew, it has now shown up.

Last edited by GraemeSS; 04-06-2020 at 07:30 PM. Reason: No longer relevent
Reply With Quote
  #3  
Old 04-10-2020, 04:02 PM
p45cal's Avatar
p45cal p45cal is offline Trying to DO Auto Update 12 Month Rolling Chart Windows 10 Trying to DO Auto Update 12 Month Rolling Chart Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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

Thread Tools
Display Modes


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
Trying to DO Auto Update 12 Month Rolling Chart Auto update excel graph range, ignore data when date reads 00-Month-00 SavGDK Excel 2 06-24-2016 08:05 AM
Trying to DO Auto Update 12 Month Rolling Chart 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft