Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
How Can I Graph from an Equation in Excel? Ex: P=-.0056Q + 12 or P=.0033Q +
8 Thank you in advance for any help! Mike |
#2
![]() |
|||
|
|||
![]()
One way:
In A1, enter "Q", in B1, enter "Result". In A2:Axxx enter the domain of the function (the Q-values you want to look at, e.g., 1 to 100 in A2:A101). In B2, enter =-0.0056*A2 + 12, and copy down for as many rows as you filled in column A. Select a cell in the data range. Click the Chart Wizard, and choose an X-Y scatter graph (with or without lines). Finish the wizard.. In article , "Michael Kintner" wrote: How Can I Graph from an Equation in Excel? Ex: P=-.0056Q + 12 or P=.0033Q + 8 Thank you in advance for any help! Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a graph from an equation and not a set of data? | Charts and Charting in Excel | |||
how do I graph a linear equation? | Charts and Charting in Excel | |||
Bar graph values keep changing | Charts and Charting in Excel | |||
Graph Axes | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |