Results 1 to 4 of 4
  1. #1


    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

    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!


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

  3. #3

    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

    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
  •