Excel Graph Help - Printable Version
-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: Excel Graph Help (/showthread.php?tid=81710)
Excel Graph Help by LoochTheMan on 02-17-2008 at 03:27 AM
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.
![[Image: f_helpm_e00b0d8.png]](http://img27.picoodle.com/img/img27/4/2/16/f_helpm_e00b0d8.png)
RE: Excel Graph Help by ddunk on 02-17-2008 at 03:45 AM
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.
RE: RE: Excel Graph Help by LoochTheMan on 02-17-2008 at 03:51 AM
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.