Creating a chart in excel

hashemen

New Member
Joined
Jul 4, 2012
Messages
3
Hi,

i'm a very new user at excel and forums, so please be patient with me.

I do reading tests, and would like to graph the results, I have a sheet with the name of the student on top with what text being tested on, which i guess will be the title of the chart, i then have the the date tested, how long it took to read the text eg: 1:04 (1 minute 4 seconds), and the amount of mistakes eg: 4 (4 mistakes) I then review the same text a few days later and again record the same data, please help me graph this for parents to see their childrens approvement.

my thoughts are the dates will be at the bottom the times at the left with a line coming from the left and number of mistakes on the right with a line coming from the right?

even if this is correct i will still need step by step instructions how to do this.

thank you
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Welcome to the Board!

It sounds like you need a Magnitude chart, which allows you to display disparate data sets on two axes. In this case I'd imagine that you could use completion time as a column chart on the primary axis, and mistakes as a line chart on the secondary axis. If you want to post a shot of your sheet (see the link in my sig), someone can probably mock up an example for you. Or you can PM me your address and I'll send you an example.

Note that you'll want to communicate your e-mail address via the Private Message feature, and not post it directly on the board, where it's a spam target (on this and any other public forum).

HTH,
 
Upvote 0
Hi Smitty

Thank you so much for your reply.

I have sent you a detailed reply through private message.

Best Wishes.
 
Upvote 0
Dear Smitty,

Thank you for your sample Magnitude chart.

As you suggested I'll post one childs' real results, and if someone can send me through a sample of how to enter it correctly in to excel to create Magnitude chart.

Name: Abraham
Text: Little red ridinghood Pg's 1 - 4
1 March 2012 - 5 minutes 17 seconds - 10 mistakes
19 March 2012 - 3 minutes 0 seconds - 6 mistakes
30 March 2012 - 3 minutes 28 seconds - 4 mistakes
25 April 2012 - 2 minutes 32 seconds - 6 mistakes
09 May 2012 - 2 minutes 23 seconds - 0 mistakes
23 May 2012 - 2 minutes 46 seconds - 1 mistake
10 June 2012 - 2 minutes 30 seconds - 0 mistakes

Again Thank you.
 
Upvote 0

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top