Auto Replot

Mills · Post by **Mills** » Sun Mar 08, 2015 5:39 pm

Is there any way to get DPlot to automatically update a plot when the Excel data set is changed?

For example, if I change the Excel input value from 45 deg to 60 deg, can DPlot automatically change the surface contour plot?

Post by **DPlotAdmin** » Mon Mar 09, 2015 1:07 am

There's only one way to do this. Rather than using the Add-In functions to get your data to DPlot, use Copy (in Excel), then Edit>Paste Special with the Link box checked in DPlot. Changes to the data in Excel will result in automatic changes to the graph in DPlot.

The main downside to this is Copy/Paste copies your numbers as text exactly as they are formatted in your Excel spreadsheet. IOW if you only see 2 decimal places in Excel, that's all that will be pasted in DPlot. So if you need more precision you'll need to change the formatting in Excel.

Mills · Post by **Mills** » Sun Mar 29, 2015 12:39 am

Is the DPlot data in a simple tabular form - a long list of:

x1, y1, z1
x2, y2, z2
etc

If so, that may not work for me. My spreadsheet data is an array:

-----x1, x2, x3,...
y1, z11, z21, z31,...
y2, z21, z22, z23,...
y3, z31, z32, z33,...

I suppose I could create another spreadsheet to reformat the data into the Dplot format but,...

Mills · Post by **Mills** » Sun Mar 29, 2015 12:40 am

Why do I always get an error message when I try to post to this forum?

Post by **DPlotAdmin** » Sun Mar 29, 2015 11:15 am

For Copy/Paste that format won't work, which you've already discovered. I'll add an option to accept that format.

You get an error (strangely on some systems, but not others) when you reply to anyone. The error has to do with sending a notification e-mail to the person you're replying to. There's something wrong with the mail script that used to work fine. I've stared at it a while and haven't figured it out yet.