Help with bars in bar chart

[Antney]

Hi,

I'm creating a bar chart and I have rows of data that I am using to create
it. It's pretty simple, but now, my boss wants me to add the # of students
who were involved. Previously I was just using %'s. Here's how the data
looks:

Grd StuTotal Comp# % Voc# % Wrtng# %
1 1603 533 33%
2 1312 456 35% 436 33% 311 24%
3 1009 201 20% 121 12% 105 10%
4 777 100 13% 52 7% 87 11%
5 645 96 15% 108 17% 77 12%

I was using the percentages to create the bar chart, by grade, which is
simple, but now I need to add the # of students. The chart only wants to
accept only one data series. How can I make it accept two. Have the % and #
of students in the same column?

Let me know if unclear.

Thanks,

Antney

 

[Jon Peltier]

I would make a bar chart with number of students, and add custom labels with
the percentages. You can use one of these two free add-ins to add custom
labels easily:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon