Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plz can u solve this | Excel Discussion (Misc queries) | |||
Can you solve this???? | Excel Worksheet Functions | |||
CAN YOU SOLVE THIS!!!!!!! | Excel Worksheet Functions | |||
Solve for X and Y | Excel Worksheet Functions | |||
y i cannot solve it ? | Excel Worksheet Functions |