Limited
March 12th, 2009, 06:37 PM
Sup, okay basically I have a graph that shows whether something is Low, Medium or High. My bars are fine, however the vertical axis shows numbers. I want it to only show 3 things, the Low/Medium/High thing.
Heres example
Current:
http://img25.imageshack.us/img25/7827/currentm.png
What I want:
http://img25.imageshack.us/img25/1007/want.png
Any one got any ideas? I'm using Excel 2007.
Just to point out, for now my cell data is using numbers, 3 = High, 2 = Medium, 1 = Low. I can change that if I need to.
Edit: Ok I'm slowly getting there using this: http://www.ozgrid.com/Excel/CustomFormats.htm
[=1]"Low";[=2]"Medium";
That works, but I require 3.
Heres example
Current:
http://img25.imageshack.us/img25/7827/currentm.png
What I want:
http://img25.imageshack.us/img25/1007/want.png
Any one got any ideas? I'm using Excel 2007.
Just to point out, for now my cell data is using numbers, 3 = High, 2 = Medium, 1 = Low. I can change that if I need to.
Edit: Ok I'm slowly getting there using this: http://www.ozgrid.com/Excel/CustomFormats.htm
[=1]"Low";[=2]"Medium";
That works, but I require 3.