Excel: Editing, Plotting and Graphing Equations - Not Tables of Numbers
Excel: Editing, Plotting and Graphing Equations - Not Tables of Numbers
(OP)
Excel defaults to a "standard" way of producing graphs -> simple x,y plots of the numbers in a table. You produce a table of numbers in columns, it produces any variety of "plots of dots"
But, I want to "test" the output of equations (in my case, the data is for temperature, wet-bulb temperature, wind speed, and pressure over several years for data taken every hour each day) themselves.
What I'd like to do is estimate equations approximating these different values, "test" then against the data by plotting the equations and their data at various resolutions of time and years (sometimes plotting all the years over top of one another by day-of-year, some times looking at min-max and average data for the month, etc. Then, re-edit the equations and try again.
Frankly, I'm not sure what I'm going to find, so I don't know what I'll need to do - but I don't want to just look at or re-plot 32,000 data points every time..
Is there an Excel "equation editor" or add-on program that lets you display and plot equations themselves (4th order, 5th 6th order polynominals or the sum of sin and cosine waves for example) without forcing the user to "plot a table" ?
But, I want to "test" the output of equations (in my case, the data is for temperature, wet-bulb temperature, wind speed, and pressure over several years for data taken every hour each day) themselves.
What I'd like to do is estimate equations approximating these different values, "test" then against the data by plotting the equations and their data at various resolutions of time and years (sometimes plotting all the years over top of one another by day-of-year, some times looking at min-max and average data for the month, etc. Then, re-edit the equations and try again.
Frankly, I'm not sure what I'm going to find, so I don't know what I'll need to do - but I don't want to just look at or re-plot 32,000 data points every time..
Is there an Excel "equation editor" or add-on program that lets you display and plot equations themselves (4th order, 5th 6th order polynominals or the sum of sin and cosine waves for example) without forcing the user to "plot a table" ?





RE: Excel: Editing, Plotting and Graphing Equations - Not Tables of Numbers
You can use VBA to create the array and plot it.
But frankly it seems to me to be not worth the effort.
I'm sure how, but I suspect that with the dynamic table features in the latest versions of Excel you could set things up on a spreadsheet to be able to enter the parameters and coefficients that you want to play with to accomplish what you are interested in.
RE: Excel: Editing, Plotting and Graphing Equations - Not Tables of Numbers
You might check and see if they have a demo or limited version available since the main program is pretty expensive but it does a lot of heavy lifting.
RE: Excel: Editing, Plotting and Graphing Equations - Not Tables of Numbers
http://newtonexcelbach.wordpress.com/2010/12/15/ch...
If not, please let us know what they don't do, and I am sure it can be fixed.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Excel: Editing, Plotting and Graphing Equations - Not Tables of Numbers
http://www.jkp-ads.com/Articles/ChartAnEquation05....
followed by my blog article if you want to plot parametric equations.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Excel: Editing, Plotting and Graphing Equations - Not Tables of Numbers
RE: Excel: Editing, Plotting and Graphing Equations - Not Tables of Numbers
RE: Excel: Editing, Plotting and Graphing Equations - Not Tables of Numbers
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
Of course I can. I can do anything. I can do absolutely anything. I'm an expert!