+ Reply to Thread
Results 1 to 1 of 1

Unable to make lines on a graph move through an arc whilst maintaining y intercept

  1. #1
    Registered User
    Join Date
    11-15-2011
    Location
    Bristol
    MS-Off Ver
    Mac Excel 2008
    Posts
    1

    Unable to make lines on a graph move through an arc whilst maintaining y intercept

    I'm new to this forum and have only just started to realise the benefits of using Excel in a capacity other than office related work! I've been using it a lot recently as part of my Motorsport Engineering degree to model the behaviour of certain principles. My latest is an indepth analysis of a vehicle suspension system.

    I am trying to simulate the effect of a car wheel going over a bump of, for example 25mm. I have created a graph with x and y axis representing distance. I have then plotted two lines that represent the top and bottom wishbones of a suspension (these are at slight angles from the horizontal, as per my required design). What I am now trying to do is create a function where you enter a specific bump height into a cell, and this moves the lines up accordingly. The problem is that these lines have to pivot at the y intercept (as they would on a car), which means the line will be moving in an arc rather than straight up. Another problem is that both lines must remain the same length, set by my required design. The idea behind this is to assess the change in camber as the vehicle hits the bump. I have been working on it for days and tried all sorts of combinations with no luck. Any ideas would be much appreciated! I have included the workbook for reference.

    Many thanks!!
    Attached Files Attached Files
    Last edited by ace-card; 11-15-2011 at 06:44 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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