Y Axis values on bar charts

M

mr_teacher

hi,

I am trying to create a bar chart to show the results of tests in my
class. I have been able to complete a bar chart easily enough and this
shows the results accurately. I have used a VLOOKUP function to give
the levels the children achieved a numerical value and the graph is
calculated from this

e.g. a level 2a = 1 a level 3c = 2 a level 3b = 3 etc.

IS it possible that instead of having numbers showing on the Y axis I
can somehow convert these back to show the actual levels? So instead of
the point number equivalent it actually shows what the childs level
would be?

Thanks for any advice you can offer me - hope it all makes sense too
what I am trying to do!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
How to use labels instead of values for Y axis 1
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
customise y axis on clustered bar chart 1
Swap Y-Axis numbers 3
Graphs: 2 Lines on secondary Y-axis? 1
Changing Y-Axis Labels from Numerical to Textual 1
How do I put a marker line on an excel chart (i.e. on y axis)? 1

Top