Orbiter-Forum Creating a specific graph in Excel 2016
 Register Blogs Orbinauts List Social Groups FAQ Projects Mark Forums Read

 Math & Physics Mathematical and physical problems of space flight and astronomy.

05-17-2019, 07:56 PM   #1
Dickie
Wannabe Rocket Scientist

Creating a specific graph in Excel 2016

As part of my degree I'm doing a question which requires me to plot radial strain and hoop strain against the radial position of where the measurements were taken. I have the data in a spreadsheet in Excel 2016 (attached) and so am trying to plot row 25 (mean strain, separated into columns of H for hoop strain and R for radial strain) against row 30 (radial position in mm for each measurement).

No matter how I try and input this data into the graph function I can't get a plot of hoop strain (i.e all the H columns) and radial strain (i.e again all the R columns) with strain on the Y axis and radial position on the X axis. At the end I should have 2 separate lines for H and R strains.

I freely admit to not being an excel ninja so I may be missing something obvious but can anyone offer some advice with this?
Attached Files
 OEL (2).zip (12.6 KB, 3 views)

 05-17-2019, 08:34 PM #2 Urwumpe Certain Super User The problem is, that you essentially want to plot just the odd or even columns there. It would be possible if you create distinct H and R rows for the same radial position. I would create a hidden table there and fill all cells in a row with a SELECT function.
 Thanked by:
 05-19-2019, 01:46 PM #3 statickid CatDog from Deimos you mean something like this? this is an xy plot with series lines added. if you want to make something like this in excel you have to specify the x series and then add whatever y series exist. then the data have to be in order (x ascending) Last edited by statickid; 05-19-2019 at 01:52 PM.
 Thanked by:
 05-20-2019, 07:47 AM #4 Dickie Wannabe Rocket Scientist Thanks, I ended up stripping the data out into another table and then producing a graph like the one in the image which seemed to work.

 Posting Rules BB code is On Smilies are On [IMG] code is On HTML code is Off You may not post new threads You may not post replies You may not post attachments You may not edit your posts
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Orbiter-Forum.com     Announcements     Meets & Greets Orbiter Space Flight Simulator     Orbiter Web Forum         OFMM         Orbiter Forum Space Station         Simpit Forum     General Questions & Help     MFD Questions & Help     Hardware & Software Help     Tutorials & Challenges     Orbiter SDK     Orbiter Visualization Project     Orbiter Beta » Orbiter Project Orbiter Addons     OrbitHangar Addons & Comments     Addons     Addon Development     Addon Requests     Addon Support & Bugs         Addon Developer Forums             Project Apollo - NASSP     Orbiter Lua Scripting Far Side of the Moon     Spaceflight News     Math & Physics     Astronomy & the Night Sky     Backyard Rocketry     Brighton Lounge     International Forum

All times are GMT. The time now is 09:47 PM.