stacked column chart

[palaeontology]

I have a stacked column chart for the data found in the range Sheet1!A2:A16.

The stacked column chart uses an individual circle (black outline, white inner) to represent each student in a group of about 200 students.

The x-axis bears the scale ... A+ A A- B+ B B- C+ C C- D+ D D- E+ E E-

The y-axis bears the frequency of each of those 'Performance Grades'.

For example, there are 3 students who received an A+, so there are three circles above the A+

There are 5 students who received an A, so there are 5 circles above the A

etc etc etc

What I would like is to have the very top circle of a particular column appear black outline and black inner.

So if, let's say, cell Sheet1!D2 bears the value B+, and the cell Sheet1!E2 bears the value 7, then the 7th circle at the very top of the B+ column of circles should appear completely black, in contrast to the other circles that are black outline with a white inner.

Is there a way to place a single circle at the position indicated by cells D2 and E2 ?

Kind regards,

Chris

 

[pgc01]

Hi Chris

You just have to split the series in 2:
- the first one with the values minus 1
- the second one with all values equal to 1

and then stack the 2 series.
Fill the first series with 1 type of circles and the second with the other.

 

[palaeontology]

PGC, thank you so much.

I've actually been stuck on this problem for perhaps 12 years, but is such a simple solution.

Thankyou again,

kindest regards,

Chris

 

[pgc01]

You're welcome. I'm glad it helped.