Maybe if I list the limitations of Excel with XML, then you could use that as a guide to start something.
-
XML will not let us start the graph at any sequence number. The Excel graph always starts at zero no matter what you do with the graph source sequence range. Allow the user to set the start seq # and end seq # for the graph display.
-
A custom program should look up the sequence intervals (within the XML file) and recompute a horizontal time-base x-axis and allow the user to modify this. Now place the data points in their respective place on the time-base x-axis.
-
Allow the user to subtract or add an offset voltage value to the data point value.
-
Allow the user to multiply the data point value by a single digit integer number.
-
Save the results as a new filename that can be reloaded later.
That would pretty much do it. This may be more than you bargained for, but that is what we need, and I will provide any help that I can.