Mechta
24th May 2011, 20:28
I'm doing a college materials assignment which requires the results of a number of tensile tests (typically 3 to 6 tests per chart) to be plotted in scatter charts (variable data in both X & Y axis). The data is in about twenty worksheets and the charts on separate worksheets within the same workbook.
I'm finding extracting the data to be longwinded and wonder if you can help with any of the following:
When selecting the data for a series it keeps jumping back to the worksheet with the chart on it rather than staying on the one from which I have to get the Series name, X axis data and Y axis data. What can I do to hold it on that worksheet until I have all three boxes filled?
If assigning a name to a column of data (to try and speed up data collection) is there some sort of wildcard to tell it to take data from the first reading to the last, given that the number of readings (and therefore the number of worksheet rows) varies from one test to the next? So far I can only find ways for taking data from columns of identical length.
Is there a place for writing strings which allows data to be collected from multiple worksheets?
Any other methods of quickly extracting data into charts would be much appreciated.
I'm finding extracting the data to be longwinded and wonder if you can help with any of the following:
When selecting the data for a series it keeps jumping back to the worksheet with the chart on it rather than staying on the one from which I have to get the Series name, X axis data and Y axis data. What can I do to hold it on that worksheet until I have all three boxes filled?
If assigning a name to a column of data (to try and speed up data collection) is there some sort of wildcard to tell it to take data from the first reading to the last, given that the number of readings (and therefore the number of worksheet rows) varies from one test to the next? So far I can only find ways for taking data from columns of identical length.
Is there a place for writing strings which allows data to be collected from multiple worksheets?
Any other methods of quickly extracting data into charts would be much appreciated.