Page 1 of 1
Auto Replot
Posted: Sun Mar 08, 2015 5:39 pm
by Mills
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?
Posted: Mon Mar 09, 2015 1:07 am
by DPlotAdmin
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.
Posted: Sun Mar 29, 2015 12:39 am
by Mills
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,...
Posted: Sun Mar 29, 2015 12:40 am
by Mills
Why do I always get an error message when I try to post to this forum?
Posted: Sun Mar 29, 2015 11:15 am
by DPlotAdmin
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.