Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Simple MS Excel Graph question

  1. Aug 7, 2012 #1
    I was watching this YT film about plotting on Excel.

    I copied the numbers from the film into an Excel sheet and plotted x against y1 and got a blue coloured plot.

    Then I plotted x against y2 and plotted a chart again. Though a second red coloured plot did not appear as in the film. Instead my original plot vanished and the second plot appeared, but again in blue.

    How do I have both the x against y1 in blue, and the x against y2 in red on the same scatter plot?

    Thank you.
    Last edited by a moderator: Sep 25, 2014
  2. jcsd
  3. Aug 7, 2012 #2


    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    A scatter plot of 2 lines requires 3 columns. x, y1, y2
  4. Aug 7, 2012 #3
    Try this,

    Make a selection (drag the mouse) from the header of X0 the upper left corner to Y2n, the lowermost right datacell. Then insert graph, scatter plot. That should do it.
  5. Aug 16, 2012 #4
    Thanks Guys!
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook