How to plot data with repeating value? Laser Spectrum Analyser Data

Hello,

I want to plot data collected from Laser on Spectrum Analyser, I have 2 Sets of data for 6 Different Resolution Bandwidths

Resolution Bandwidths:-
0.2nm | 0.5nm | 1nm | 2nm | 5nm | 10nm

for each Resolution bandwidth i have following two sets of data

Wavelength
Output Power

For a particular bandwidth the wavelength vs output power plot looks like this

lasing.jpg

but i need to plot all the data against each resolution bandwidth and show it in a single chart with repeating values in horizontal axis, i drew a rough estimate in Paint as following

my spectrum1.jpg

Can any one please guide me how to plot it as shown in the pic above?

Thnx

You need to build a panel chart.
http://peltiertech.com/Excel/ChartsH...nelChart1.html

You will probably have to generate chart data based on you original with offset values added in order to get the separate data sets to appear along the x axis.
The repeated x axis values can be done with a dummy series and linking data labels to cells.

Post small example data file, rather than images, if you need further help.

See attached with chart values on single sheet. New values calculated.
Dummy series for axis labelling.

You are a life saver...