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.
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.
You need to use the Scatter chart type instead of Line. That will allow you to define separate X values for each series.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With