Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I create a line graph based on a formula
I have been doing some regression analysis manually and have worked out a
y=mx+a formula. Is it possible to create a graph based on the fomula rather than creating a graph cost figures? My answer is y=4.5x+16.714 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I create a line graph based on a formula
Put some text in A1 and B1 (example : X and Y )
Put some x-values in A2:A20 or more In B2 use =4.5*A2+16.714 Copy down to B20 (or more) Select A1:B20 and use Chart Wizard to make XY chart best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Damo447" wrote in message ... I have been doing some regression analysis manually and have worked out a y=mx+a formula. Is it possible to create a graph based on the fomula rather than creating a graph cost figures? My answer is y=4.5x+16.714 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I create a line graph based on a formula
The answer is, yes you can, but in general it's far easier (and easier to
understand and debug) to use the approach which Bernard has suggested. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Damo447" wrote in message ... I have been doing some regression analysis manually and have worked out a y=mx+a formula. Is it possible to create a graph based on the fomula rather than creating a graph cost figures? My answer is y=4.5x+16.714 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Out of range line disappears in print as it re-enters graph | Charts and Charting in Excel | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
can i create formula giving totals based on financial & text info | Excel Discussion (Misc queries) | |||
how do I create a line graph for part of the periods? | Charts and Charting in Excel |