Two Headers, one subject column and various columns with data

[ILoveMyCorgi]

I am trying to create a simple graph chart and get bupkus! The chart
consists of:
CST RESULTS
Subject School District
2005 2006 2005 2006 2007
English-Language Arts 22 29 39 40 43
Mathematics 16 10 18 22 19
Science 29 31 31 31
History-Social Science 11 14 36 32 30

I tried various charts and nothing... what's wrong with my approach?

 

[Del Cotter]

I tried various charts and nothing... what's wrong with my approach?

Your data's laid out fine as it is. Select the rectangle including the
years and the subjects, but not the word "Subject", and run the Chart
Wizard to make a Line Chart from that. Then right-click on the chart,
select "Chart Options" and add in your headers by hand to make a title.

 

[ILoveMyCorgi]

That didn't work... I tried pie, graph, etc. and nothing! i thought maybe my
layout was a little misleading so I am labeling it below:

1 A B C D
E F
2 Subject School District
3 2005 2006 2005 2006 2007
4 English-Language Arts 22 29 39 40 43
5 Mathematics 16 10 18 22 19
6 Science 29 31 31 31
7 History-Social Science 11 14 36 32 30

I appreciate your help on this.

 

[Del Cotter]

That didn't work... I tried pie, graph, etc. and nothing! i thought maybe my
layout was a little misleading so I am labeling it below:

Just forget the whole "Subject..School..District" line, it's only
causing you trouble. Leave it out of your selection when you make the
graph.

 

[ILoveMyCorgi]

I tried the chart without the subject, school, district line... I've tried
using only one column and I still don't get a readable graph. On the pie
chart I get one line... the graph charts are worse.

 

[ILoveMyCorgi]

Sorry I haven't replied sooner... it lturned out my file was corrupt! I
reproduced my data on a separate file and Charts worked file for me. thanks
for all your help.