# Charting two Sets of Data

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!

Ad

B

#### Bruce Sinclair

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!

Assuming that the Y scales are different here and that your 9 categories are
evenly spaced, try using a bar chart for both sets of data, but with 2 Y
axes (1 on the left and one on the right).
If the student categories are not 'evenly spaced' then a scatter plot is
your only option ... but the 2 axes will work on that as well.

HTH

## Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.