Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphing R=1+E
Hi all,
I would like to plot a graph for the equation R=1+E, where at anytime I want to put a value in R it should automatically plot the value of E on the graph. Is this possible? Thanks in advance. Mas |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphing R=1+E
Whenever you want to plot a formula, you should put a list of X values in
one column, then put the formula for Y in the next column, then select the two columns and make a chart. For example, if I want to plot Y=X, I put X values in A2:A10, and in B2 I enter the formula =A2, and I fill it down to B10. The range A1:B10 will look like this: A B 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 Select A1:B10 and make an XY chart. For a simple linear equation, you only need two points, the start and end of the line, because the connecting line automatically includes all intermediate points. If you are only plotting one point, you just need the equivalent to A1:B2 above. Change what you enter for X and the value of Y will change to match. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Mas" wrote in message ... Hi all, I would like to plot a graph for the equation R=1+E, where at anytime I want to put a value in R it should automatically plot the value of E on the graph. Is this possible? Thanks in advance. Mas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP with Graphing. | Charts and Charting in Excel | |||
Graphing | Charts and Charting in Excel | |||
graphing | Excel Discussion (Misc queries) | |||
graphing | Excel Discussion (Misc queries) | |||
Graphing | Excel Discussion (Misc queries) |