+ Reply to Thread
Results 1 to 15 of 15

How to make a W/B Graph in excel?

  1. #1
    Registered User
    Join Date
    08-11-2017
    Location
    USA
    MS-Off Ver
    excel v.15.32
    Posts
    7

    Angry How to make a W/B Graph in excel?

    I'm stuck and don't wanna waste more time on the internet trying to find the solution to what I'm looking for.

    I'm making a Weight and balance excel sheet for myself, and I want to learn how to take the CG numbers to make lines on my CG envelope. take this physical sheet I have attached and the numbers I want to transfer into a graph to make dots and lines just like on this picture. the numbers that will make up the lines are the highlighted #.

    I hope you understand what I'm trying to accomplish here and can help me.

    Don't think it makes a difference but I'm on excel for MAC.


    W_B_R22_Ecell.png

    Thank you

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

    Re: How to make a W/B Graph in excel?

    Chart looks like a basic scatter chart (possibly a panel chart with two panels) with one or two closed polygons, so this should not be overly difficult in Excel. There will be some details to work out along the way, I expect. Overall procedure I would expect to see:

    1) Take data from the form and put it in a good table suitable for linking the chart to.
    2) Create and format the chart.

    While putting all of that together, pay attention to references and such so that, when all is done, you will only need to fill out the form and the chart(s) should update automatically.

    I don't know exactly what you need help with, what parts of that you already know how to do and what you will need help with. As a starting point, I might suggest a tutorial like this that shows the basic steps to drawing a closed polygon in an Excel scatter chart (including how to arrange the data in the spreadsheet and how to create the chart). http://www.excelunusual.com/tutorial-2/ The menus look like they are from Excel 2003, so you may need to consult your help files to find equivalent commands and menus in your version of Excel.

    Once you understand how to plot a closed polygon, then we can work on adapting that to your task here.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    08-11-2017
    Location
    USA
    MS-Off Ver
    excel v.15.32
    Posts
    7

    Angry Re: How to make a W/B Graph in excel?

    Thank you for the quick answer, I have done that tutorial a few times now, and I thought I knew how to get this done now. but as it turns out I don't. hehe

    In my excel file, i have made an automatic updating table when the user input values are entered.In The left collum, and the highlighted areas are the ones where I would get my CG in inches, To be plotted on the charts.

    I have managed to make the charts and formatted them to be the right size and spread on the vertical and horizontal axis. but when I did that the graph line disappeared and I can't get it back. I have made the borders on the 2 graphs thicker than what they are going to be, just to show where they are right now.

    If I could have uploaded my spread sheet I would have, then maybe someone could have told me what I'm doing wrong. but I can only figure out how to upload a picture of it.


    Workbook here: R22 W_B sheet test.xlsx
    Attached Images Attached Images
    Last edited by Av8er; 08-11-2017 at 04:28 PM.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to make a W/B Graph in excel?

    To attach a workbook, press Go Advanced, scroll down to Manage Attachments, and follow your nose from there.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    08-11-2017
    Location
    USA
    MS-Off Ver
    excel v.15.32
    Posts
    7

    Re: How to make a W/B Graph in excel?

    Thank you for that nice trick hehe I have pasted in the link to the workbook in 2 posts above this but here is another one, if some of you might wanna try to help me out. I'm sure it's an easy thing I have done wrong. but as an Excel NUBI, i'm losing a lot of hair!

    Attachment 532928

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: How to make a W/B Graph in excel?

    Not sure what you are stuck on.

    Based on the picture (specifically the top chart), here's what I would have expected to find:

    1) A list of 7 X,Y values for each vertex of the hexagon (remember that you need to duplicate the first vertex in order to close the polygon:
    Please Login or Register  to view this content.
    Other than the 1370, I cannot see where any of those values should come from in the main table in rows 1:10, so I have no thoughts or ideas (other than simple =B10 type formulas like you are already using) on how to make this list.

    With that list in place, creating the top chart should have been as easy as Insert -> Chart -> Scatter -> line without marker. Then make sure that Excel used the first column for the X values and the second column for the Y values.

    A similar procedure would be used to create the bottom chart.

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to make a W/B Graph in excel?

    I always wanted to do one of these ...
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    08-11-2017
    Location
    USA
    MS-Off Ver
    excel v.15.32
    Posts
    7

    Re: How to make a W/B Graph in excel?

    WOW shg.

    Thank you, You are good, I've been doing this for 8 hours now and have not been able to figure this out. I'm no mathematician, I'm a pilot, but I'm trying to learn how to do these in excel, so I can make these for more advanced aircraft's that I'm flying. Would you mind making me a short tutorial on how you manage to do that? and is there a way to show the lines on the graphs with an arrow pointing where it goes from (TOT. T/O --> TOT. ZFM)?

    if you don't want to do a full tutorial, can you show me how you set up that table, to get the lines in the right places and what value you put where in the X Y axis?

    It's using the numbers I get and setting up the table to show the right numbers and get the graph line to match up with the point on the graph grid. that I think I'm only having trouble with.

    Sorry, I'm not very good at this. but I'm trying to learn

  9. #9
    Registered User
    Join Date
    08-11-2017
    Location
    USA
    MS-Off Ver
    excel v.15.32
    Posts
    7

    Re: How to make a W/B Graph in excel?

    Thank you, where do you get the
    95.5 -- 1275
    95.5 -- 910
    102 -- 910
    102 -- 1175

    From? I'm just trying to learn. probably something I don't understand. lol

  10. #10
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to make a W/B Graph in excel?

    Would you mind making me a short tutorial
    Andy Pope has an ocean of info on charts: http://www.andypope.info/charts.htm

    is there a way to show the lines on the graphs with an arrow pointing where it goes from (TOT. T/O --> TOT. ZFM)?
    See attached.

    where do you get the
    95.5 -- 1275
    ...
    I read them off your chart, but you should definitely verify them.
    Attached Files Attached Files
    Last edited by shg; 08-11-2017 at 11:57 PM.

  11. #11
    Registered User
    Join Date
    08-11-2017
    Location
    USA
    MS-Off Ver
    excel v.15.32
    Posts
    7

    Re: How to make a W/B Graph in excel?

    Thank you shg, I will check out AndyPope. how do i Flip the arrows on the chart? right now they go from Empty to Full, I need them to go from Full to empty. So I can see the right direction of how the Center of Gravity is moving when be burn fuel.

  12. #12
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to make a W/B Graph in excel?

    Modify the formulas in rows 17/18 so that they appear in the opposite order.

    E
    F
    G
    H
    I
    15
    Fueled to Empty
    Fueled to Empty
    16
    Station
    Weight [lb]
    Station
    Butt Line
    17
    98.2
    1,370
    98.2
    0.9 L
    18
    97.0
    1,197
    97.0
    0.5 L

  13. #13
    Registered User
    Join Date
    08-11-2017
    Location
    USA
    MS-Off Ver
    excel v.15.32
    Posts
    7

    Re: How to make a W/B Graph in excel?

    Thank you so very much. I'll probably still be pulling my hear out, I hate when I can't figure how to do this with out having to ask for help. hehe

  14. #14
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to make a W/B Graph in excel?

    You're welcome.

  15. #15
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to make a W/B Graph in excel?

    To save your hair, if necessary ...
    Attached Files Attached Files
    Last edited by shg; 08-12-2017 at 12:10 AM.

+ 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. how to make this kind of graph in excel
    By ijazali in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 12-15-2014, 07:49 AM
  2. How can I make a graph like this in excel?
    By Mat87 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 07-20-2014, 02:34 PM
  3. How to make this graph in Excel?
    By Beg9inner in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-09-2013, 07:33 AM
  4. Can I make this graph in excel?
    By MarketingAnalyst in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-21-2011, 10:07 AM
  5. Make a graph with excel
    By Bunsenbrenner in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-26-2008, 05:40 AM
  6. [SOLVED] How do I take a picture and make it a graph in Excel?
    By DavidBr318 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-05-2006, 11:55 AM
  7. [SOLVED] How to make a stairs graph in Excel?
    By peter in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-19-2005, 05:05 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