xyz scatter plot - incorrect axis label when using Excel

VBA and general Excel Q&A and examples

Moderator: DPlotAdmin

Post Reply
W Mickanin
Posts: 1
Joined: Mon Feb 01, 2010 11:06 am

xyz scatter plot - incorrect axis label when using Excel

Post by W Mickanin »

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
User avatar
DPlotAdmin
Posts: 2312
Joined: Tue Jun 24, 2003 9:34 pm
Location: Vicksburg, Mississippi
Contact:

Post by DPlotAdmin »

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
Post Reply