View previous topic :: View next topic |
Author |
Message |
Mills
Joined: 07 Mar 2015 Posts: 6
|
Posted: Sun Mar 08, 2015 5:39 pm Post subject: Auto Replot |
|
|
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? |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2310 Location: Vicksburg, Mississippi
|
Posted: Mon Mar 09, 2015 1:07 am Post subject: |
|
|
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. _________________ Visualize Your Data
support@dplot.com |
|
Back to top |
|
|
Mills
Joined: 07 Mar 2015 Posts: 6
|
Posted: Sun Mar 29, 2015 12:39 am Post subject: |
|
|
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,... |
|
Back to top |
|
|
Mills
Joined: 07 Mar 2015 Posts: 6
|
Posted: Sun Mar 29, 2015 12:40 am Post subject: |
|
|
Why do I always get an error message when I try to post to this forum? |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2310 Location: Vicksburg, Mississippi
|
Posted: Sun Mar 29, 2015 11:15 am Post subject: |
|
|
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. _________________ Visualize Your Data
support@dplot.com |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|