xyz scatter plot - incorrect axis label when using Excel
Posted: Mon Feb 01, 2010 11:25 am
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
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