Automatically Update Quarterly Graphs

Hey all,

I am currently working on a project and am having difficulty getting my quarterly graphs to automatically update when new data is entered. Below I will provide my project objectives, what I am already doing and what I am stuck on;

Objective:
-Trend monthly flow rates from a number of years in both annual and quarterly graphs
-Enable my excel sheet to automatically update graphs when new monthly data is added

Currently doing:
-I have one sheet designated to data input and quarterly flow rate calculations and a number of other sheets designated to graphs

For my annual graphs:
-I have made a number of 'defined names' which my graphs reference to update automatically
Here is an example of the code I am using for my defined names

=OFFSET('Flows and Data'!$V$5,0,0,COUNTA('Flows and Data'!$V:$V)-1)
This allows me to enter new monthly data and autoupdates my annual graphs fine.

Now on my main data sheet 'Flows and Data' I use the following formula to generate quarterly values from my monthly data:
=SUM(OFFSET(AI$5,(ROW()-ROW($AI$5))*3,0,3,1))

Problem:
In order to generate quarterly graphs I have to manually select which cells to extract data from. I want to some how set my excel file up that I can continue to add monthly values, have my quarterly calculations run and then automatically update my quarterly graphs to incorporate the newly added data.


If anyone has dealt with this or has any suggestions I would greatly appreciate their time/efforts!
Thanks,
Doug

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"