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="IvanLasston" data-source="post: 1039716" data-attributes="member: 145676"><p>You mention pages and numbers. If you are using numbers</p><p>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.</p><p></p><p>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.</p><p></p><p>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?</p><p></p><p>[ATTACH=full]12665[/ATTACH]</p></blockquote><p></p>
[QUOTE="IvanLasston, post: 1039716, member: 145676"] 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? [ATTACH=full]12665[/ATTACH] [/QUOTE]
Verification
Post reply
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Excel to numbers
Top