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 

xyz scatter plot - incorrect axis label when using Excel

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



Joined: 01 Feb 2010
Posts: 1

PostPosted: Mon Feb 01, 2010 11:25 am    Post subject: xyz scatter plot - incorrect axis label when using Excel Reply with quote

Firstly: DPlot is a great product and a super value - for my work it adds an essential capability to Excel(tm).

1) Using Dplot add-in from Excel 2007 (all current updates) with xyz data selection of a pair of columns (x,y) then (control down arrow) the third column (ie 3 columns are not contiguous).
Columns have text headers like "X", "Y", "resistance value" formatted in default text, bold, wrapped and centered. Have anywhere from 20k to 60k rows of data in dataset.

Find that the x-axis label is always the first number in the x-column, not the label (index off by one?). Once corrected, replots ok - but annoying to fix every time.

2) (Unrelated) If using multiple spreadsheets (all 20-50MB), sometimes will get error "Dplot lib not found" when trying to do (any) plot. Closing all but 1 spreadsheet does not fix this, sometimes have to completely exit and restart Excel - seems like Excel is scarfing up all memory etc. and shutting Dplot lib out somehow - probably not a Dplot problem but just fyi. (Running Excel 2007, 32 bit Win Vista, 3GB memory, hp Pavillion dv6830 laptop)

Thanks,
W. Mickanin
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


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

PostPosted: Mon Feb 01, 2010 1:23 pm    Post subject: Reply with quote

Thanks for your comments.

1) Are you selecting the column heading, too? (You need to.) If you are, this isn't the behavior I'm getting. If the first cell in the X selection is non-numeric, it is assumed to be a label. Otherwise that's where the data starts (as far as the XYZSurface command is concerned). If that isn't what you're getting you are welcome to send me an example.

2) "Dplot lib not found". This shouldn't happen after yesterday's update. DPLOTLIB.DLL is no longer used. If you didn't get the update, use Check for Updates on the Help menu in DPlot to download the latest.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
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