I want to draw several graphs and combine them into one shape. 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 determine the coordinate).
X - Y
_____
1 - 5
2 - 5
5 - 7
9 - 10
Chart # 2
X - Y
_____
6 - 8
8 - 12
9 - 7
12 - 8
15 - 11
21 - 11
What I do is create a chart and click "Select Data." There I create two series and select the values of X and Y. However, this does not work, because it does not allow me to choose different values of X for different graphs. Although I choose different X values for these two series, the second one is selected for both. Here's what it looks like at the end:
Do you know how to fix this? I am using Excel 2008 for Mac.
source
share