Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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:

screenshot

Do you know how to fix this? I'm using Excel 2008 for Mac.

like image 223
Ivan Avatar asked May 31 '12 16:05

Ivan


People also ask

How do you show multiple series in Excel chart?

To create a combo chart, select the data you want displayed, then click the dialog launcher in the corner of the Charts group on the Insert tab to open the Insert Chart dialog box. Select combo from the All Charts tab. Select the chart type you want for each data series from the dropdown options.


1 Answers

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

like image 65
MvanGeest Avatar answered Sep 24 '22 13:09

MvanGeest