New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Switcher Hangout The place for switchers to discuss their new machines, and how to work with OS X. General support can be had here for newbie stuff, like "How do I restart my new iMac?" :)

Excel to numbers


Post Reply New Thread Subscribe

 
Thread Tools
elvisharwen

 
Member Since: Apr 20, 2010
Posts: 1
elvisharwen is on a distinguished road
Mac Specs: MacBook Pro OSX

elvisharwen is offline
I've just got a macbook pro as my first mac and I'm loving it, but having some teething problems...

I'm a physicist so spend a LOT of time on excel (and now pages) analysing data. Could anyone answer me a few questions?

1) On excel there is a function which allows you to double click the bottom right corner of a cell, and the data automatically fills all the way to the bottom of that column. I know you can use this corner to 'drag' the data down, but when you've got 1800 rows this takes quite a while!

Alternatively, if this is not possible, can you speed up the rate at which data can be dragged down (so I suppose scroll rate maybe?) as I've just spent nearly 5 minutes scrolling down the page!

2) How do you put two sets of data on one graph? On excel this was easy by just highlighting 3 columns of data rather than 2, but seemingly not possible in Numbers?

3) Once you have a graph, and you put a line of best fit in (I have used inspector for this) is it possible to extrapolate the line (for example, so you can see the y-intercept, or to estimate values outside the range you have data for).

Any help would be much appreciated!
Thanks
Georgia
QUOTE Thanks
TechieJustin

 
TechieJustin's Avatar
 
Member Since: Dec 16, 2008
Location: Pennsylvania, USA
Posts: 298
TechieJustin is on a distinguished road
Mac Specs: Macbook Pro 15"

TechieJustin is offline
Assuming you're using Excel 2008 so I'll tackle number one.
Put your beginning value in the top column - or where you want it to begin.
Select the column where you want to put the incremental numbers.
Click on EDIT -> FILL then SERIES.
Enter your step value, and the ending value and you're done!


There is no 'bottom' of the column. It will go on forever if you keep scrolling down.
Attached Images
File Type: jpg Screen shot 2010-04-20 at 4.57.27 PM.jpg (116.9 KB, 27 views)
QUOTE Thanks
IvanLasston

 
IvanLasston's Avatar
 
Member Since: Feb 26, 2010
Location: Rocky Mountain High, Colorado
Posts: 2,116
IvanLasston is a splendid one to beholdIvanLasston is a splendid one to beholdIvanLasston is a splendid one to beholdIvanLasston is a splendid one to beholdIvanLasston is a splendid one to beholdIvanLasston is a splendid one to beholdIvanLasston is a splendid one to beholdIvanLasston is a splendid one to behold
Mac Specs: 1.8 GHz i7 MBA 11" OSX 10.8.2

IvanLasston is offline
You mention pages and numbers. If you are using numbers
1) Select the bottom most cell you care about - 1800 in your case. Hold shift - and click to the cell you want to fill with at the top of the column - Insert -> fill down or Fill up - depending on which way you want to fill.

2)I selected 3 columns - and it does plot them on the same graph. Now it seems alot more limited on how you get to select x and y axis but inspector seems to have choices on how to deal with it a bit.

3) In inspector click show equation - set X to 0 and that should get you your y intercept - and in theory you should be able to use that equation to extrapolate no?
Attached Images
File Type: png Screen shot 2010-04-20 at 3.48.14 PM.png (346.4 KB, 10 views)
QUOTE Thanks
TechieJustin

 
TechieJustin's Avatar
 
Member Since: Dec 16, 2008
Location: Pennsylvania, USA
Posts: 298
TechieJustin is on a distinguished road
Mac Specs: Macbook Pro 15"

TechieJustin is offline
Oops...
I thought he was using Office.
Anyway its nice to see Macs being used in the sciences.
QUOTE Thanks

Post Reply New Thread Subscribe


« Safari Auto refresh | Migration from windows is done thanks to i5 MBP..2 q's.. »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
mac excel numbers display after decimal moonlitegram OS X - Apps and Games 12 06-03-2013 12:13 PM
Numbers - transferring data from sheet to sheet VIPeR OS X - Apps and Games 6 11-27-2009 12:50 PM
Changing serial for Excel for Mac pegasus OS X - Apps and Games 1 04-08-2008 10:27 AM
Excel vs. Numbers - Help please ekologik OS X - Apps and Games 3 03-05-2008 10:47 AM
did work on numbers, pc friend cannot view with excel tacsniper OS X - Apps and Games 3 12-29-2007 08:50 PM

All times are GMT -4. The time now is 08:48 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?