How to draw an approximation graph in excel

[Dil09]

Hi everyone, I have two sets of data in excel. I want to plot them over X and Y axis with different color and draw a linear center line to check how different they are. But I could not make this. I added a picture how exactly I want them to draw. Please help.

 

[vletm]

Dil09
You should able to send an Excel-file with a sample data.
or
#1 Select Your data
#2 Insert XY-chart
#3 Modify series colors
... and so on.

 

[Dil09]

Hi, I added an excel file. With the two sets data A and B I want to plot a graph like the added picture. Is it possible that the data in column A shows red and B blue? Also the straight line starting from the origin (showed in the picture) how to create this? Thanks

 

[vletm]

Dil09
For two xy-chart-series (A & B) You needs four columns data.
Your given data could show like below.

Something is still missing.

 

[Hui]

I assume that A & B are 2 sets of Y values
What is the X Axis values for the data?