PDA

View Full Version : Microsoft Excel Graph Axis - Using Text



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.

Syuusuke
March 12th, 2009, 07:17 PM
Do you have to hand in the actual xls (or whatever file)?


Oh and...
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

Limited
March 12th, 2009, 07:21 PM
Well this is the best I've been able to come up with, I could set the minimum scale to 1, however that would mean nothing would be shown for Low =\.

http://img26.imageshack.us/img26/7953/picz.png
Sadly the syntax is, if, elseif, else. I really want, if, elseif, elseif, else.