Previous Topic Next Topic

Plotting number and text onto the same chart

Closed
David - May 21, 2010 at 06:13 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 21, 2010 at 08:55 AM
Hello,
o
I'm currently working on a chart to present some data using excel.

I work as an educator and want to present my students academic growth year on year, the basic way our levels system works is such:

1i, 1ii, 2i, 2ii, 3i, 3ii, 4,5,6,7,8, 1C, 1B, 1A, 2C, 2B, 2A


Now I'm happy to present 1i as 1.1 and this works well for my purposes, however when I have a student who has level 1C for example I can't plot it on the same chart, what I think I need is this - a way to display 1C in the table, but report the value as '9' to the chart so that it appears correctly in sequence.

Is anyone able to offer a clever answer to this? It's driving me mad, I mean at a pinch I can display 1C as 9 in the table but frankly it's unprofessional and bothers me.

Please help!

Related:

3 responses

Answer 1 / 3
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 21, 2010 at 07:44 AM
How about if you have a formula based table on which you base you graph
some thing like

=IF(sheet1!a1="1c", 9, sheet1!a1)
this way you can show 1c and have graph show 9
0
Answer 2 / 3
David
May 21, 2010 at 08:21 AM
Unfortunately not quite rizvisa as that would still show 9 on the chart's axis whereas I need it to display 1C - essentially I want to make excel count 4,5,6,7,8,1C,1B
0
Answer 3 / 3
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 21, 2010 at 08:55 AM
Could you please upload a sample file with sample data and GRAPH on some shared site like https://authentification.site , http://wikisend.com/ etc and post back here the link to allow better understanding of how it is now and how you foresee.
0