Hi,


I have the following data:

X Red Green Blue Intensity
0 64 69 72 67.847

And so on for 300 rows. I Have 80 sets of this data (before and after) to graph. My goal is to have the graphs side by side and have a pull down to indicate the sample (1-40) and update the before and after graph. I have done this before using pivot tables when I needed to graph averages, but not when math isn't needed on the data.

Thanks in advance for your ideas

Tim

Hi
You could use a macro. Simply record a macro to update each of your graphs. Once you have done that make sure the macro is only stored in this document. The rename the macro as a AutoOpen macro. This macro will then run each time you open the document. Otherwise you could leave the macro name as is and run it when you need to.
Hope this helps.
Good luck.
Tony(OTPM)