Rae -
Start with this data:
Grades
Bad 50
Okay 30
Good 20
Select this range and make a stacked column chart, with series in rows.
These are your colored bands; format them in red, yellow, and green
fill, with no borders.
Now the students' data:
Math Science Literature
Mary 23 38 36
John 46 63 39
Bill 53 89 24
Select the data, copy, select the chart, paste special from the edit
menu, as new series. These mess up the nice arrangement you just made.
One by one, double click on these added series, and on the Axis tab,
select Secondary (or just do one, then select each of the others and
press F4 to repeat).
Now right click on the chart, select chart options, and on the Axes tab,
check the box for secondary X axis. The new series all went upside down,
no big deal. Now we have to move axes all around.
Double click the primary Y axis (on the left), and on the scale tab,
check the crosses at maximum box. Double click on the secondary (right)
Y axis, and uncheck this box. Double click the primary X axis (now on
the top), and check the axis crosses at maximum box. Double click the
secondary X axis (bottom) and uncheck this box. Finally, right click on
the chart, click on Chart Options, and uncheck the primary Y axis box.
You can do more formatting if desired. Set the maximum of the Y axis to
100. Hid the top X axis by double clicking, and on the patterns tab,
choosing None for major and minor ticks and tick labels. If you wanted
the other series as line chart series, right click one, choose chart
type, and change it, then select each of the others and press F4 to repeat.
- Jon