B
Bob
Hello,
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!
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!