Hi there,
Take a look at the attached version of your workbook and see if it does what you need.
To include the latest set of data in the graph, just copy downwards the last row of the new data table.
Just out of interest I added a feature which allows you to select a specific channel (Red, Green, Blue) which automatically updates the values being displayed and changes the colour of the chart title and the graph to suit the colour of the selected channel:
The highlighted value may be changed to suit your own requirements.
Hope you find this useful/interesting.
Regards,
Greg M
Bookmarks