If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Simple MS Excel Graph question

Smythe · 2012-08-07 18:40:22

I was watching this YT film about plotting on Excel. http://www.youtube.com/watch?v=2uWvEC2BPxE 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…

07-08-2012 6:40pm

#1

Smythe

Registered Users, Registered Users 2 Posts: 434 ✭✭

Join Date: March 2010

Posts: 232

I was watching this YT film about plotting on Excel.

http://www.youtube.com/watch?v=2uWvEC2BPxE

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.

0

Comments

#2 08-08-2012 12:21pm

Delphi91

Registered Users, Registered Users 2 Posts: 1,501 ✭✭✭

Join Date: May 2001

Posts: 1401

If you select all THREE columns at the same time, and then proceed to do the scatter graph, you'll get what you're looking for. The colouring may not be correct, but that's up to you to change that.

0