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.