Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Sep 25, 2008, 11:33 PM   #1
teflon
macrumors 6502a
 
teflon's Avatar
 
Join Date: May 2007
Plotting 2 lines in the same graph in Excel

I'm doing a lab, and I was wondering if it's possible to plot 2 lines on the same graph in Excel for Mac 2004. For example, the points could be (1,3), (2, 4), (3, 5). Then keeping the same x, another line would form with points (1, 5), (2, 7), (3,8). So then there would be two different lines on the same graph.

Also, if it's possible, can you make it so that the two lines are in different colours and have a legend indicating which is which?

Thanks in advance .
__________________
Got a question? MRoogle it!
teflon is offline   0 Reply With Quote
Old Sep 25, 2008, 11:34 PM   #2
swiftaw
macrumors 603
 
swiftaw's Avatar
 
Join Date: Jan 2005
Location: Omaha, NE, USA
Yes, it's absolutely possible.

You need 3 columns, one for the x-coords, and one each for the two sets of y-coords.

Last edited by swiftaw; Sep 26, 2008 at 12:20 AM.
swiftaw is offline   0 Reply With Quote
Old Sep 26, 2008, 12:05 AM   #3
teflon
Thread Starter
macrumors 6502a
 
teflon's Avatar
 
Join Date: May 2007
Ohhhhh! Right... don't I feel stupid now .

Thank you!
__________________
Got a question? MRoogle it!
teflon is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Visual Basic Module/Macro works in Windows Excel but not Mac Excel 2011 chrispy1042 Mac Applications and Mac App Store 2 May 4, 2014 07:41 AM
Formulas in Excel on Mac... Switch to values in Excel on PC Noob2mac Mac Applications and Mac App Store 2 Apr 24, 2013 05:24 AM
Plotting the switch, but when? chaseychasem MacBook Pro 13 Aug 27, 2012 03:49 PM
Plotting Multiple Points In New Maps App? newyorksole iOS 6 7 Aug 13, 2012 12:12 PM
Creating Pivots in Excel 2011 that can be used in Excel 2003 (Windows) Extreme Red Mac Applications and Mac App Store 2 Jun 5, 2012 09:51 AM

Forum Jump

All times are GMT -5. The time now is 07:19 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC