DPlot Forum Index DPlot
http://www.dplot.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Linking Excel Data with DPlot graphs

 
Post new topic   Reply to topic    DPlot Forum Index -> Excel
View previous topic :: View next topic  
Author Message
jwolfson



Joined: 11 Dec 2006
Posts: 3

PostPosted: Fri Jan 12, 2007 1:21 pm    Post subject: Linking Excel Data with DPlot graphs Reply with quote

Is it possible to link an excel spreadsheet with a Dplot graph? I am working with some spreadsheets and exported data to DPlot graphs. Now I have found an error in my spreadsheet and need to correct it which changes all of the data points that I plotted. Do I need to make all new graphs again or is there a way that can link the two files so that it would automatically update all of the graphs when I change the data?

Thanks,

Janet
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Fri Jan 12, 2007 5:31 pm    Post subject: Reply with quote

Quote:
Is it possible to link an excel spreadsheet with a Dplot graph?


Yes, but it probably won't be much help in this case. The link is only active as long as both DPlot and your spreadsheet in Excel remain open. (Links are not saved to DPlot files, in other words.) As soon as you close either the DPlot document or the Excel sheet, the link is severed.

If I've misunderstood what you want to do, take a look at the DPlot Help file's "Insert Link" topic.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Tue Sep 30, 2008 12:14 am    Post subject: Reply with quote

Wandering through past posts:

Quote:
The link is only active as long as both DPlot and your spreadsheet in Excel remain open. (Links are not saved to DPlot files, in other words.)


This is no longer true, and hasn't been for the past several versions. Links are now saved to DPlot files, and when you reopen a DPlot file it will attempt to reestablish the link. So if your Excel spreadsheet has changed, the plot in DPlot will change as well.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
JDog



Joined: 19 Mar 2010
Posts: 4

PostPosted: Thu Mar 25, 2010 7:18 am    Post subject: Reply with quote

To DPlotAdmin,

Yes this is true on the DPlot side.

I used this feature to copy a 3D Scatter Plot and paste special with link in excel. When I open excel it tries to update the link to no avail as it tries to launch dplot.exe and gives an error.
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Thu Mar 25, 2010 8:22 am    Post subject: Reply with quote

Excel is relying on some sort of OLE gizmo that DPlot doesn't use (and won't in future releases). There's nothing to be done about this one, sorry.

From your mail:
Quote:
Until now I have the evaluation version of DPlot. I had the IT guys purchase the licence, and are due to install the full version. Has this got to do anything with it or am I missing something?

Nothing to do with the trial vs. the licensed version. What you're hoping to happen isn't going to happen.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
JDog



Joined: 19 Mar 2010
Posts: 4

PostPosted: Thu Mar 25, 2010 12:29 pm    Post subject: Reply with quote

OK thanks a million
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> Excel All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
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