Ok here's the thing, I have spectral data, thousands of data points and I took 220 spectra of different locations/sides, different parts and different lots. I need to merge the groups of data for comparison and overlay them, typically about 30-60 lines per chart. The source charts are 10-20 lines and formatted a certain way. I need to preserve the formatting as I merge the charts or batch format subsets quickly as this will take several days to do it 1 by 1, and it is impossible to select every line. These are X,Y Scatterplot. I am using Office 2013.
I have been copy-pasting them together.
**I have tried FILE>OPTIONS>ADVANCED>CHART and deselected follow chart formatting, this has partially worked but has failed on the graphs with 60 and above lines.
Thanks!
I have been copy-pasting them together.
**I have tried FILE>OPTIONS>ADVANCED>CHART and deselected follow chart formatting, this has partially worked but has failed on the graphs with 60 and above lines.
Thanks!