change y-axis


  1. Posts : 29
    64 bit
       #1

    change y-axis


    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'?
      My Computer


  2. Posts : 784
    Linux Mint 17 Cinnamon | Win 7 Ult x64
       #2

    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.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 13:38.
Find Us