help creating a chart

dleonard78

New Member
Joined
May 22, 2011
Messages
9
Im not sure its possible but can someone help me if they can?!?

below are the grade boundries for a GCSE subject and I want to create a 1 column chart for pupils to show how far they are away from acheiving certain grades!

I want to create something that has the grades an numbers across the bottom access with 1 column that is coloured up to the grade the pupil has actually achieved - so for example the column would be coloured up to 97 and then a different colour up until 111 to show the pupil has 97 marks but represent how far away they are from the A* grade.:


Does this make any sense? and can anyone help please or suggest another way!

thanks
Dan
33G
46F
59E
72D
87C
95B
103A
111A*



<colgroup><col style="width: 48pt;" span="2" width="64">
<tbody>


</tbody>
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Forum statistics

Threads
1,215,239
Messages
6,123,818
Members
449,127
Latest member
Cyko

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top