• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel - plot for multiple values of x

scooterscot

I live on CUK
Joined
Nov 8, 2005
Messages
22,519
Likes received
1,802
Thanks received
454
Location
Anywhere that is not broken Brexit Britain
Is it possible? Possible to plot from a single formula calculated multiple times over for where x-0.....6 for example?

Really want to avoid going into matlab, which seems overkill.
 
Is it possible? Possible to plot from a single formula calculated multiple times over for where x-0.....6 for example?

Really want to avoid going into matlab, which seems overkill.
Yep. Start reading up on Array Formulas...
 
Yep. Start reading up on Array Formulas...

Oh no, not those. It's a valid point right enough, but you have to trigger them every time you wish to calculate if I remember.. but that might not be a bad thing. Thanks.
 
May have mis-read but can't you add a column with the input values you want to use, and another with the formula values for those inputs, and feed that into a graph?

Not very elegant but wouldn't it do the job?
 
May have mis-read but can't you add a column with the input values you want to use, and another with the formula values for those inputs, and feed that into a graph?

Not very elegant but wouldn't it do the job?

Not when the formula has 20+ coefficients, too much scope for human error at that point. Also I'd like to test for different coefficients, not always the same one. Matlab is good for this but is overkill and expensive to maintain.
 
When excel fails me I turn to Grapher. The amount of times this little app has saved my bacon. In this example Sc is calculated 50 times over for sequential values of x.

Screen%20Shot%202014-10-02%20at%2016.29.06.png
 
If you need to do these sort of things regularly, consider R (Matlab is fine too, as is the open-source version, Octave, but R is extremely powerful and has a massive user community). It will take you a while to learn, but it's almost never "overkill" vs something like Excel, because you could do this in a couple of lines of script, rather than faffing with cells and formulas in Excel.
 
If you need to do these sort of things regularly, consider R (Matlab is fine too, as is the open-source version, Octave, but R is extremely powerful and has a massive user community). It will take you a while to learn, but it's almost never "overkill" vs something like Excel, because you could do this in a couple of lines of script, rather than faffing with cells and formulas in Excel.

I never expected to get a hit googling 'R'!

I'm guessing you mean: The R Project for Statistical Computing
 
I never expected to get a hit googling 'R'!

I'm guessing you mean: The R Project for Statistical Computing

Sorry :laugh Yes, exactly. It takes a while to learn, since it's all script-based, but it's incredibly powerful and widely used, with an excellent user/support community. It's pretty much the standard for statistical computing (the proprietary equivalent of the R language is S-plus in case that rings any bells..).
 

Advertisers

Back
Top