Results 1 to 3 of 3

Thread: Should be a simple graph, but I'm an Excel newb

  1. #1

    Question Should be a simple graph, but I'm an Excel newb

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Since this is my first post here, I'd like to thank anyone who can help upfront.

    The problem I am faced with is I only need to graph 1 line with 2 highlighted points on a graph. Unfortunately it needs to be graphed inside of another "graph" or more specifically the limits for the weight and balance of a helicopter.

    Here is a quick picture of what I am trying to do:

    Click image for larger version. 

Name:	Excel Graph problem.jpg 
Views:	18 
Size:	98.0 KB 
ID:	2894

    Here is a copy of my Excel workbook: Astar W&B.xlsx

    Of particular note is that all I need on the graph is the relationship of the helicopter weight to the center of gravity (CG) in pounds and inches. Weight should be on the vertical axis with a range of about 2800 to 4400 pounds, CG should be on the horizontal axis from around 121 to 141 inches. If you have trouble reading the numbers to form the "limits" of the graph, please let me know.

    Thanks again for any help!

  2. #2
    Seeker DSDressler's Avatar
    Join Date
    Dec 2014
    Bend, OR

    revised W&B

    You need to add a Scatter chart with the limits and add data to the chart that contains your CGs. Not sure of your Lat. Moments. Hope this helps.

    Astar W&B.-rev.xlsx

  3. #3
    Thank you DSDressler. I am not concerned about the lateral moments at this time. I will play with what you sent and appreciate the help!

Posting Permissions

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