#1   Report Post  
Michael Kintner
 
Posts: n/a
Default Graph an Equation

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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a graph from an equation and not a set of data? ashemorry Charts and Charting in Excel 1 January 20th 05 10:14 AM
how do I graph a linear equation? Throstle Charts and Charting in Excel 3 January 10th 05 05:19 PM
Bar graph values keep changing Mike82j2000 Charts and Charting in Excel 1 January 6th 05 01:27 PM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 08:03 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"