change y-axis

[droidus]

i have a graph, and on the y-axis, the response is either yes or no. right now, it is set to 0 or 1, misrepresenting the data. can i change that 1/0 to a word, like 'yes' or 'no'?

 

[TanyaC]

You could try a custom format for the cells;

"Yes";-;"no"

Note though that all positive values will be displayed as Yes. Also, as this is just formatting other formulas (if any), will still consider the cell value to be 0 or 1 since you are changing the display format, not the actual cell value.

The other way to do this is to add another row/column with an if statement and use that column as your y-axis.

if(A1=0,No,if(a1=1,Yes,""))

If the value of A1 is other than 0 or 1 the above will return a null value. This method also has the advantage that if you want to use other formulas to work with yes/no values, it will work, whereas the cell formatting will not.