+ Reply to Thread
Results 1 to 2 of 2

Calculating X axis of a graph using a varying parameters

  1. #1
    Registered User
    Join Date
    01-21-2022
    Location
    Dublin, Ireland
    MS-Off Ver
    16.0
    Posts
    11

    Calculating X axis of a graph using a varying parameters

    Hi,

    I have a calculation used in the booked for required thrust (Answer shown in pink). This value changes based on a number of parameters as shown. These can't be hardcoded into the thrust equation as they have to be changable. I would like to make a graph showing Velocity on the x axis and then the required thrust for each velcoity value in the y axis. Is there any way of using a formula / even VBA to automatically calculate the thurst values using the given equations over a range of values?

    Since there are mutiple things that can be changes I'd prefer to not just copy the equations across for each value of V

    Any help would be very appreciated
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,897

    Re: Calculating X axis of a graph using a varying parameters

    I'm not sure why you are resistant to the idea of designing a spreadsheet so that you make copies of the desired calculation. When I want to calculate "y" at multiple given "x" values (no matter how complicated y=f(x) might be), I almost always prefer to arrange the spreadsheet in a way that I can program the calculation once (usually into a single row or column), then make copies of the row/column.

    Having programmed the spreadsheet as it is, probably the easiest way to get what you want without revisiting the design of the spreadsheet is a data table: https://www.excel-easy.com/examples/data-tables.html You should be able to use the information in G2:G4 to create a column of velocities, then build a data table that will calculate thrust at each of those velocities.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Varying scale on the Y-Axis
    By SMEx in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-15-2020, 09:33 AM
  2. changing axis in line graph - label axis should be on y-axis
    By Falimus in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2020, 04:56 PM
  3. Line graph with varying x ad y axis values
    By samjna in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 10-23-2012, 09:07 PM
  4. Varying parameters in IF statements: negative time
    By karlkr245 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2011, 11:30 AM
  5. Varying data on X axis
    By coa01gsb in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-06-2006, 10:55 AM
  6. [SOLVED] varying y-axis
    By etraleigh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-07-2005, 03:05 PM
  7. Varying axis scaling
    By jeffnoll in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-18-2005, 10:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1