View previous topic :: View next topic |
Author |
Message |
W Mickanin
Joined: 01 Feb 2010 Posts: 1
|
Posted: Mon Feb 01, 2010 11:25 am Post subject: xyz scatter plot - incorrect axis label when using Excel |
|
|
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 |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2311 Location: Vicksburg, Mississippi
|
Posted: Mon Feb 01, 2010 1:23 pm Post subject: |
|
|
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 |
|
|
|
|
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
|