Bork Bork!
 FAQ  •  Search  •  Memberlist  •  Usergroups   •  Register  •  Profile  •  Log in to check your private messages  •  Log in
 Any Excel Experts??? View next topic
View previous topic
Post new topicReply to topic
Author Message
Shumpy
Certified Geek


Joined: 10 May 2003
Posts: 214
Location: That place called Media

PostPosted: Wed Jan 07, 2009 11:11 am Reply with quoteBack to top

Hi All!

Question So, Derek is trying to help me figure out a way to make a combination chart/graph on Excel. Essentially, I want to graph ranges of scores for a standardized test and then on the same chart/graph, I want to plot the scores of each student. I don't care if it's a line/bar graph, etc. Derek has managed to have it graph the ranges (ie - below level, average level, above level) but we cannot figure out how to get it to plot the individual scores. Question

Can anyone help?! I'd REALLY appreciate it!!!!

_________________
~"Sometimes the only sense you can make out of life is a Sense of Humor." ~
View user's profileSend private messageAIM AddressYahoo Messenger
jewles
Satanist Bitch


Joined: 02 May 2003
Posts: 920
Location: Newark, DE

PostPosted: Thu Jan 08, 2009 10:36 am Reply with quoteBack to top

I'm a little confused as to what exactly you want. Aren't the ranges the same for every student? What does your chart for the ranges look like?

P.S. I know there are custom chart types that let you do crazy things but I haven't used them much.
View user's profileSend private messageSend e-mailAIM Address
Shumpy
Certified Geek


Joined: 10 May 2003
Posts: 214
Location: That place called Media

PostPosted: Thu Jan 08, 2009 12:01 pm Reply with quoteBack to top

We have the initial chart with the ranges already. It's a bar graph and the ranges are color-coded (red, yellow, green). I know there are custom combination charts, but I have no clue how to create them.

Essentially, I want to plot the student scores ONTO the existing chart that shows the ranges (so that the parent/teacher can identify where the student falls).

_________________
~"Sometimes the only sense you can make out of life is a Sense of Humor." ~
View user's profileSend private messageAIM AddressYahoo Messenger
jewles
Satanist Bitch


Joined: 02 May 2003
Posts: 920
Location: Newark, DE

PostPosted: Fri Jan 09, 2009 9:49 am Reply with quoteBack to top

When you open the chart wizard in excel and there are a list of chart types, there is a tab at the top for custom types. On that there is a line - column type. Maybe that will work. Note that I have excel 2002 here at work so newer versions might have different options but you should be able to search the help for how to use custom chart types.
View user's profileSend private messageSend e-mailAIM Address
Shumpy
Certified Geek


Joined: 10 May 2003
Posts: 214
Location: That place called Media

PostPosted: Fri Jan 09, 2009 9:59 am Reply with quoteBack to top

Thanks Jules - I did find that already but I still don't know how to get it to plot the data points on there *sigh*. Guess I'll just keep trying unless someone else chimes in here!

_________________
~"Sometimes the only sense you can make out of life is a Sense of Humor." ~
View user's profileSend private messageAIM AddressYahoo Messenger
Display posts from previous:      
Post new topicReply to topic


 Jump to:   



View next topic
View previous topic
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
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme :: All times are GMT - 5 Hours