mechanicaldup
Mechanical
is it a possible to plot a funtion in excel like y=x + x^2 without determining various y values for various x values first?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
ploting a function in excel 1
- Thread starter mechanicaldup
- Start date
- Status
-
1
- #4
cummings54
Chemical
You can create a plot without having the X's & Y's appear in a worksheet. You can define X and Y as a formula Names. Then reference the names in the series function used to draw the plot on s chsrt
For example:
Create the following names using the Insert:Name
efine command.
Name Refers To:
X ---> ={1;2;3;4;5}
Y ---> =X+X^2
Then the series command will be simillar to
=SERIES(,Book1.xls!X,Book1.xls!Y,1)
For example:
Create the following names using the Insert:Name
efine command.Name Refers To:
X ---> ={1;2;3;4;5}
Y ---> =X+X^2
Then the series command will be simillar to
=SERIES(,Book1.xls!X,Book1.xls!Y,1)
- Status
Similar threads
- Locked
- Question
