How to solve: y=1/x, x0
 

The major obstacle here is how to make MS Excel 2002 automatically inpu
x-values in ONE cell, read off the result from the cell containing th
formula. Then I want Excel to export both the input x-values an
calculated y-values to another place in the spreadsheet, another sheet
or directly into a graph (thus making a lovely hyperbola.)

I have googled my way around the Internet several times and there ar
plenty of pages explaining how to make a x-column and a y-column, an
you end up copying and pasting thousands of x-values and thousands o
the equation down to row #thousands. Although, it would be ok if Exce
needed to export the RESULTS to thousands of cells. Because then
could just highlight the whole columns with the chart wizard.

I need Excel to do this, because I am doing financial budgeting wit
hyperbolic-like equations. Are there add-ins, functions, VB-scripts, o
similar that do this?

I would appreciate any help on the matter!

Cheers,
balle klori

--
Message posted from http://www.ExcelForum.com

How to solve: y=1/x, x0
 

Hi
see:
http://www.tushar-
mehta.com/excel/software/plot_manager/index.html

-----Original Message-----
The major obstacle here is how to make MS Excel 2002
automatically input
x-values in ONE cell, read off the result from the cell
containing the
formula. Then I want Excel to export both the input x-
values and
calculated y-values to another place in the spreadsheet,
another sheet,
or directly into a graph (thus making a lovely hyperbola.)

I have googled my way around the Internet several times
and there are
plenty of pages explaining how to make a x-column and a y-
column, and
you end up copying and pasting thousands of x-values and
thousands of
the equation down to row #thousands. Although, it would
be ok if Excel
needed to export the RESULTS to thousands of cells.
Because then I
could just highlight the whole columns with the chart
wizard.

I need Excel to do this, because I am doing financial
budgeting with
hyperbolic-like equations. Are there add-ins, functions,
VB-scripts, or
similar that do this?

I would appreciate any help on the matter!

Cheers,
balle klorin


---
Message posted from http://www.ExcelForum.com/

.

How to solve: y=1/x, x0
 

Just wanted to say thank you very much! A very simple solution and exactly what I needed.

Cheers,
balle klorin

"Frank Kabel" wrote:

Hi
see:
http://www.tushar-
mehta.com/excel/software/plot_manager/index.html

-----Original Message-----
The major obstacle here is how to make MS Excel 2002
automatically input
x-values in ONE cell, read off the result from the cell
containing the
formula. Then I want Excel to export both the input x-
values and
calculated y-values to another place in the spreadsheet,
another sheet,
or directly into a graph (thus making a lovely hyperbola.)

I have googled my way around the Internet several times
and there are
plenty of pages explaining how to make a x-column and a y-
column, and
you end up copying and pasting thousands of x-values and
thousands of
the equation down to row #thousands. Although, it would
be ok if Excel
needed to export the RESULTS to thousands of cells.
Because then I
could just highlight the whole columns with the chart
wizard.

I need Excel to do this, because I am doing financial
budgeting with
hyperbolic-like equations. Are there add-ins, functions,
VB-scripts, or
similar that do this?

I would appreciate any help on the matter!

Cheers,
balle klorin


---
Message posted from http://www.ExcelForum.com/

.