-
Solved: Excel Graph w/cubic function
The attached image is an Excel chart I created (for my daughter's research data) based on 4 time series (plotted as points, no need to identify as separate entities) the blue curve is something I drew in, but it represents a cubic function (as created in SPSS with the same data). She prefers the appearance of Excel to SPSS but would like the blue line plotted not drawn. The cubic function equation is
53.8538929166713 + 46.64544988975923 * x +
-10.05852960664259 * x*x + 0.5421132687450991 * x*x*x
Can anyone advise on how I might introduce this to the chart I can upload the worksheet if needed. Stan
-
Hi Stan,
Something like this?
Please post the data if you need more
Regards
Malcolm
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
-
OMG - It was that easy... Got it, ignore my last post... Thanx again. Stan
-
You're testing my very limited charting skills, but this is what I got
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules