Go Back   Orbiter-Forum > Far Side of the Moon > Math & Physics
Register Blogs Orbinauts List Social Groups FAQ Projects Mark Forums Read

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

Thread Tools
Old 05-17-2019, 07:56 PM   #1
Wannabe Rocket Scientist
Dickie's Avatar
Default 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
File Type: zip OEL (2).zip (12.6 KB, 3 views)
Dickie is offline   Reply With Quote
Old 05-17-2019, 08:34 PM   #2
Certain Super User
Urwumpe's Avatar


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.
Urwumpe is offline   Reply With Quote
Thanked by:
Old 05-19-2019, 01:46 PM   #3
CatDog from Deimos
statickid's Avatar

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.
statickid is offline   Reply With Quote
Thanked by:
Old 05-20-2019, 07:47 AM   #4
Wannabe Rocket Scientist
Dickie's Avatar

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.
Dickie is offline   Reply With Quote

  Orbiter-Forum > Far Side of the Moon > Math & Physics

Thread Tools

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

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

Quick Links Need Help?

About Us | Rules & Guidelines | TOS Policy | Privacy Policy

Orbiter-Forum is hosted at Orbithangar.com
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Copyright 2007 - 2017, Orbiter-Forum.com. All rights reserved.