Previous Topic Next Topic

Compare 2 data sets in excel

Closed
Evilseed - Jul 28, 2010 at 03:58 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 30, 2010 at 08:15 AM
Hello everybody,

this is the scenario:
I have 2 spectrometers that aquire data. I need to compare the aquired data and in order to do so I wand to create a line chart witch wavelength as X-axis label and intensity as Y-axis label.

#1: 195nm to 410nm (X-Axis data) which detects 2047 datapoints
#2: 195nm tm 1190 (also X-axis data) which detects 3647 datapoints

How can I get these two data sheets in one line chart using different categories (X- axis labels)

The first device has a smaller stepwidth and if I use the data from device #2 the wavelenths do not correspond anymore...

I'm using Microsoft Excel 2003

Thank you very much in advance :)

1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Jul 30, 2010 at 08:15 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0