Graph creation and plot points - confussed

Screen Shot 2015-07-23 at 10.55.47.png

All,

I am very new here (1st post) as I normally try to find answers for myself before reaching out. In this instance I have no choice as I am just completely stuck!

I was hoping that there would be someone out there with the necessary skills to explain to me how to create a graph that is very 'specific' in its representations. It is to do with aviation weights and balance. There are a multitude of these sorts of things out there on the internet but I don't simply want to use one of these as I need to ensure that the content displayed is absolutely accurate and correct for our specific aircraft hence why I have started from scratch. I have completed the worksheet that contains all of the necessary formula and input data. I am not just grappling with how to get this data / information into a graphical representation.

I'm not really sure I have explained this well however if those out there are able / willing if you searched the internet for helicopter weight and balance you will get a number of examples that probably better describe what I am trying to recreate.

Thank you in advance

Rotorbez

edit

Ideally I would really like the output graphic to look similar to this however the plotting of the shape (this is important as they represent actual limits / constraints) is confusing me let alone then getting the data into said graphic, which by its very nature is dynamic based on the inputs (the green cells) in the other sheet.

Screen Shot 2015-07-23 at 11.38.27.png

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Your plot looks like a basic scatter plot. I think a lot of these kind of questions end up being about how to arrange data in the spreadsheet. For something like this, I would aim for something like:

Please Login or Register  to view this content.

Once you get the data in this "list" format, the scatter plot should be easy to create from the Insert -- scatter command.