• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Moving Date (Dynamic) Graph

JPT

New Member
I have 2 series of data that are collected hourly that I want to create a scatter plot and have a reference line. This is done. I want to plot the data on a weekly basis based on stating the start and stop dates and have the graph update automatically. I have a vba macro (from PeltierTech - THANKS) that runs to standardise the graph axes dimensions. In the example workbook the question is how do I use values in H7 & H8 to get a moving (dynamic) graph for any selected weekly period. i.e. changing values in H7 & H8 for a different week to be plotted? I understand that it will involve either OFFSET or INDEX but not sure of formula syntax.
 

Attachments

  • Moving Date Graph.xlsm
    82.6 KB · Views: 4
Like this:
upload_2017-7-3_13-39-12.png
See attached file:

The chart uses Named Formula
Refer to the Name Manager
 

Attachments

  • Moving Date Graph.xlsm
    41.8 KB · Views: 20
Back
Top