Shoutbox

I am trying to get these two sets of points to be modeled. Column A are the scatter points, and column B is the line. When after graphing them as a scatter graph, I selected the column A data and pressed "Change Series Chart Type" and changed it to show a line. When doing so, the points for the scatter plot do not match their corresponding x-values, and I cant seem to get them to use the same X-axis scale.

If anyone can help me with this problem, I would greatly appreciate it.

So you want it to do something like this?

I just selected all three columns of data and created a scatterplot, then right clicked on a data point that i wanted to be a line and hit "Change Series Chart Type" and changed it to the XY graph with a line.

quote:

---

Originally posted by ddunk
I just selected all three columns of data and created a scatterplot, then right clicked on a data point that i wanted to be a line and hit "Change Series Chart Type" and changed it to the XY graph with a line.

---

When I do that, my values get arranged the way it shows in my picture. Im using Office '07 if it makes any difference.