B

#### Bob

I am working with Excel 2007. I am looking to chart some data and I can not

figure out how it is possible. I want to create a chart that shows how

students have performed on a test (% of students at a certain level) and

show

the progress towards meeting a target. It would display the data for 9

categories of students. I am thinking that a scatter plot for the target

number for each category and a bar graph of the # students at or above that

level for each category. I am having a hard time creating that on one

chart.

I can do the scatter plot, and I can do the bar graph but I do not know how

to put them both on the same axis.

Really, I want people to look at the target for each group (each of the 9

groups can/may have a different target) and see how close the students are

to meeting the target.

Any help would be great!