Results 1 to 4 of 4
  1. #1
    Excel to numbers

    Member Since
    Apr 20, 2010
    Posts
    1
    Specs:
    MacBook Pro OSX
    Excel to numbers
    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

  2. #2
    Excel to numbers
    TechieJustin's Avatar
    Member Since
    Dec 16, 2008
    Location
    Pennsylvania, USA
    Posts
    298
    Specs:
    Macbook Pro 15"
    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!
    Excel to numbers-screen-shot-2010-04-20-4-57-27-pm-jpg

    There is no 'bottom' of the column. It will go on forever if you keep scrolling down.
    Attached Images Attached Images

  3. #3
    Excel to numbers
    IvanLasston's Avatar
    Member Since
    Feb 26, 2010
    Location
    Rocky Mountain High, Colorado
    Posts
    2,116
    Specs:
    1.8 GHz i7 MBA 11" OSX 10.8.2
    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 Attached Images

  4. #4
    Excel to numbers
    TechieJustin's Avatar
    Member Since
    Dec 16, 2008
    Location
    Pennsylvania, USA
    Posts
    298
    Specs:
    Macbook Pro 15"
    Oops...
    I thought he was using Office.
    Anyway its nice to see Macs being used in the sciences.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. EXCEL lover - NUMBERS...ah...hate it!
    By Dublin RIP in forum Switcher Hangout
    Replies: 19
    Last Post: 01-22-2015, 02:20 PM
  2. excel numbers
    By liz.onishi in forum OS X - Operating System
    Replies: 7
    Last Post: 09-14-2013, 01:25 PM
  3. Page numbers in Excel for Mac
    By khowell in forum OS X - Apps and Games
    Replies: 2
    Last Post: 03-01-2013, 01:26 PM
  4. Excel/Numbers question
    By brianwmay in forum OS X - Apps and Games
    Replies: 3
    Last Post: 04-12-2008, 04:55 AM
  5. Excel vs. Numbers - Help please
    By ekologik in forum OS X - Apps and Games
    Replies: 3
    Last Post: 03-05-2008, 09:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •