Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Excel to numbers
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="elvisharwen" data-source="post: 1039663" data-attributes="member: 151794"><p>I've just got a macbook pro as my first mac and I'm loving it, but having some teething problems...</p><p></p><p>I'm a physicist so spend a LOT of time on excel (and now pages) analysing data. Could anyone answer me a few questions?</p><p></p><p>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!</p><p></p><p>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!</p><p></p><p>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?</p><p></p><p>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).</p><p></p><p>Any help would be much appreciated!</p><p>Thanks</p><p>Georgia</p></blockquote><p></p>
[QUOTE="elvisharwen, post: 1039663, member: 151794"] 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]
Verification
Post reply
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Excel to numbers
Top