Drawing graphs in MS Excel somehow got complicated

Posted by Ivan on Stack Overflow See other posts from Stack Overflow or by Ivan
Published on 2012-05-31T16:23:34Z Indexed on 2012/05/31 16:40 UTC
Read the original article Hit count: 285

Filed under:
|

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 that I 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 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.

© Stack Overflow or respective owner

Related posts about excel

Related posts about graph