| Register  | FAQ  | Search | Login 
It is currently Mon Dec 22, 2014 12:47 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: I need Excel help, please!
PostPosted: Thu Jun 19, 2014 1:38 pm 
Offline
Discovered unobtainium
User avatar

Joined: Tue Oct 19, 2010 9:21 pm
Posts: 12279
Location: Dinosaur Stampede
I hate the newest versions of Excel. I can't figure out how to graph anything anymore. I used to do scientific graphs all the time; now I feel like a fluff head.

Here is what I need/want to do:

Make a column graph with names on the x-axis. Four columns per student: Pretest, midterm, final with values from 0-50. Then another column with values going up to 530 (minimum value doesn't matter too much as long as the range is from ~300-530 but ideally the value for 400 would roughly line up with a 30-33 on the opposite scale.) I have some blank scores.

I've tried looking for some good tutorials, but haven't found any that are helpful for this.

_________________
"This is the creepiest post ever if you don't know who Molly is." -Fee
"a vegan death match sounds like something where we all end up hugging." -LisaPunk


Top
 Profile  
 
 Post subject: Re: I need Excel help, please!
PostPosted: Thu Jun 19, 2014 2:01 pm 
Offline
A Bad Person
User avatar

Joined: Mon Oct 11, 2010 5:24 pm
Posts: 3080
Location: Soy City
Wow. I can get the fourth column on a secondary Y axis, but I'm having a hell of a time getting it to display that column as part of the same series.


Top
 Profile  
 
 Post subject: Re: I need Excel help, please!
PostPosted: Thu Jun 19, 2014 2:04 pm 
Offline
Queen Bitch of Self-Righteous Veganville
User avatar

Joined: Sun Sep 05, 2010 2:21 pm
Posts: 10879
Location: Illinoize
Have you tried turning it and turning it back on and then throwing the whole mess out the window?

_________________
"The Tree is His Penis"

The tree is his penis // it's very exciting // when held up to his mouth // the lights are all lighting // his eyes start a-bulging // in unbridled glee // the tree is his penis // its beauty, effulgent -amandabear


Top
 Profile  
 
 Post subject: Re: I need Excel help, please!
PostPosted: Thu Jun 19, 2014 3:28 pm 
Offline
Discovered unobtainium
User avatar

Joined: Tue Oct 19, 2010 9:21 pm
Posts: 12279
Location: Dinosaur Stampede
mrsbadmouth wrote:
Have you tried turning it and turning it back on and then throwing the whole mess out the window?


First thing I tried!

I'm seriously ready to draw it by hand in Adobe Illustrator.

_________________
"This is the creepiest post ever if you don't know who Molly is." -Fee
"a vegan death match sounds like something where we all end up hugging." -LisaPunk


Top
 Profile  
 
 Post subject: Re: I need Excel help, please!
PostPosted: Thu Jun 19, 2014 8:41 pm 
Offline
Discovered unobtainium
User avatar

Joined: Tue Oct 19, 2010 9:21 pm
Posts: 12279
Location: Dinosaur Stampede
Still haven't figured it out (,Anne because I took a long nap), but this is amusing:

Image

_________________
"This is the creepiest post ever if you don't know who Molly is." -Fee
"a vegan death match sounds like something where we all end up hugging." -LisaPunk


Top
 Profile  
 
 Post subject: Re: I need Excel help, please!
PostPosted: Thu Jun 19, 2014 9:02 pm 
Offline
Bought A BRAND NEW CAR!
User avatar

Joined: Thu Oct 21, 2010 1:47 pm
Posts: 2192
Location: Western North Carolina
Ugh, they did make that waaaaay too hard anymore. I was starting to wonder whether I could chuck it and use graph paper or my thesis.

I know sometimes to get the grouping right, I had to mess with the organization of the data. I am going to bed now, otherwise I'd try fooling around on excel so that I don't forget the things. But maybe I'm not emotionally ready yet.

_________________
Evolved a vascular system, so I went from bryophyte to lycophyte.


Top
 Profile  
 
 Post subject: Re: I need Excel help, please!
PostPosted: Thu Jun 19, 2014 9:16 pm 
Offline
Discovered unobtainium
User avatar

Joined: Tue Oct 19, 2010 9:21 pm
Posts: 12279
Location: Dinosaur Stampede
I know! I made all kinds of advanced graphs for my geophysics paper, and those functions are really well hidden now. Or something.

I think the easiest thing to do is make my two column bar graph and then overlay a line graph for the state test scores. I'll try in the morning. If that doesn't work, I'm seriously going to just fake it in Illustrator.

_________________
"This is the creepiest post ever if you don't know who Molly is." -Fee
"a vegan death match sounds like something where we all end up hugging." -LisaPunk


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Template made by DEVPPL/ThatBigForum and fancied up by What Cheer