Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() 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!!! -- mr_teacher ------------------------------------------------------------------------ mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352 View this thread: http://www.excelforum.com/showthread...hreadid=541470 |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
Have a look at Jon's page on creating arbitrary axis scale. http://peltiertech.com/Excel/Charts/ArbitraryAxis.html Cheers Andy mr_teacher wrote: 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!!! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Zero Values in Charts | Excel Worksheet Functions | |||
Negative or zero values cannot be plotted correctly on log charts | Charts and Charting in Excel | |||
How do I set up column charts' x values in 'm' ie. 300m, 600m etc | Charts and Charting in Excel | |||
The best method for forumlas and charts??? | Excel Discussion (Misc queries) | |||
catergory on the X axis; values on the Y axis | Charts and Charting in Excel |