Your equation will be in the form y=f(x). Create two columns, one of
which is filled with values of x, and the other filled with copies of
the equation f as an Excel formula, referring to the x values. Now make
an XY Chart using these two columns.
Thanks, Are there any other method to create chart without filling out x and
y columns in excel?
I know some statistic software such as Systat, plot chart just one click
after fill out the equation.
Thanks again
Daniel
These techniques are initially pretty cool, until you're trying to track a
bug in a formula somewhere. Since you can't examine the data except in the
plot, you're in a difficult spot.
Worksheet cells are cheap and easy to use. If people didn't try to get
around using them for whatever reason, they'd have many fewer charting
difficulties.
What if you wanted to display a chart that tested values on one cell (being
x) and then plotted the y values. I want to do this because I have a
complicated spreadsheet, and instead of a simple equation, the path leads
through various sheets etc.
Or can you have a separate sheet that tests, for example if A1 equals one,
it will display what C4 will equal. Then if A1 = 2 it displays what C4 will
equal, etc.
I hope that makes sense.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
