Results 1 to 4 of 4

Thread: Chart Question

  1. #1
    2nd VP-Knowledge Base
    VBAX Master malik641's Avatar
    Jul 2005
    Florida baby!

    Chart Question

    I've attached a file with a few graphs. This question can go with any of these graphs. They are all scatter plots, BTW.

    How do I obtain values that are between two data points?

    i.e. In the "Regular Polarity" chart, what is the current [i (A)] when the voltage is 3.35?? Or at any voltage, really???

    I don't feel like performing hand calculations to do this, and I hope excel has a method for this


    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

  2. #2
    If you are willing to get close estimates of the values, then you might try reducing the major tick marks on the scale to something like 0.005 or 0.002 Use a visible grid. Then you can probably eyeball the approximate value you are looking for. Enlarging (zooming) the display would probably help. You're lucky that the graph is nearly linear.

  3. #3
    VBAX Tutor
    Mar 2005
    Excel does have some basic regression functions. You might be interested in the TREND() and LINEST() functions which you could apply to the linear portions of your chart. There is also a regression analysis tool in the Analysis Toolpack that I have never used.

    There is also an 'Add Trendline' command in one of the menus when you have a chart data series selected. This can put the fit equation in a textbox for you, but the major problem with this method is that it fits the entire data series.

  4. #4
    MS Excel MVP VBAX Tutor
    Mar 2005
    You might also query Google and Google Groups for interpolation routines, if you want the value along a line segment connecting two adjacent points. There are quite a few different routines that have been posted over the years.
    - Jon
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts