| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically solving for X or Y intercept on a log or exponential graph.
I am new to VB so hopefully this wont seem too disconnected.
I am trying to set up a sheet that automatically graphs, sets a fitline and displays the X intercept value in a cell when I enter 5 or 6 datapoints.(based on the equation of the fitline) I'm sure it's not a hard prospect, but I am not sure where to begin. I usually have 5 or 6 datpoints times about 50 samples to graph and determine the X intercepts for. The data usualy fit a log-line well. Thanks, Jed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel automatically changing my column with "E" to exponential Num | Excel Discussion (Misc queries) | |||
| Iterations & Automatically Solving If Statements | Excel Discussion (Misc queries) | |||
| set x-y crossing on graph automatically | Charts and Charting in Excel | |||
| Automatically Resizing a Graph | Excel Discussion (Misc queries) | |||
| intercept graph vs. function | Excel Worksheet Functions | |||
Linear Mode
