Orbiter-Forum  

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.

Reply
 
Thread Tools
Old 05-17-2019, 07:56 PM   #1
Dickie
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
Urwumpe
Certain Super User
 
Urwumpe's Avatar

Default

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
statickid
CatDog from Deimos
 
statickid's Avatar
Default


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
Dickie
Wannabe Rocket Scientist
 
Dickie's Avatar
Default

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
Reply

  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 12:25 AM.

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.