Chart in Access

[Green Biro]

I'm using Access 2003.

I have inserted a line graph chart using the chart wizard which charts the
value of grades students attain over several terms.

I need to change my axis to show the actual grades rather than the grade
values.

So my data for a student might be {C, B, B+} which is {40, 46, 48} but I
don't want numeric values on my Y axis - I want {E,D,C,B,A}

How can I change the axis to look the way I want it to?


Thanks in advance for any assistance.

GB

 

[Green Biro]

Hi there

Anyone out there can help?

Rephrased version of my original post:

How do I show 'lookup' values on my y-axis rather than the actual values
against which the points are plotted.

I've read up that with Excel this can be accomplished by creating a line
from a dummy series and then labelling the points with an addin.

How can I accomplish the same with my chart that's embedded into my Access
report?


Thanks in advance for any assistance.

GB

 

[John W. Vinson]

Hi there

Anyone out there can help?

Rephrased version of my original post:

How do I show 'lookup' values on my y-axis rather than the actual values
against which the points are plotted.

Base the chart on a query joining the data table to the lookup table, rather
than on the lookup table itself.

 

[Eighte]

Hello.
It may look silly but a quest. HE shall revert.
Than you.