How do I create a chart with multiple series using different X values for each series

Question

I want to draw several graphs and combine them into one figure  I will explain the problem in an example  Let s say that I want to draw two graphs with these points   Graph  1  X and Y are defining a coordinate    X - Y        1 - 5 2 - 5 5 - 7 9 - 10   Graph  2  X - Y        6 - 8 8 - 12 9 - 7 12 - 8 15 - 11 21 - 11   What I do is create a chart and click on  Select Data   There I create two series and choose X and Y values  However  this doesn t work since it doesn t allow me to choose different X values for different graphs  Although I choose different X values for these two series  the second one is chosen for both  This is how it looks like in the end     Do you know how to fix this  I m using Excel 2008 for Mac

User · Accepted Answer

You need to use the Scatter chart type instead of Line  That will allow you to define separate X values for each series

[excel] How do I create a chart with multiple series using different X values for each series?

Examples related to excel

Examples related to graph

Examples related to excel-2008