|03 Dec 2012||#2|
| || |
You could try a custom format for the cells;
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 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.
|My System Specs|
|Similar help and support threads for2: change y-axis|
|how do you add the horizontal axis labels to a scatterplot when the 'e||Microsoft Office|
|How do I see the X axis values with Excel 2010||Microsoft Office|
|Controller axis mess up. Need Help.||Gaming|
|how to run axis & allies on win 7 ??????||Gaming|
|Excel - Format Axis - Angle greyed out!?||Microsoft Office|
|Joystick axis for Halo ce||Gaming|
|Axis Media Control||Music, Pictures & Video|
|Our Sites ||Site Links ||About Us ||Find Us |
© Designer Media Ltd
All times are GMT -5. The time now is 01:24 PM.