Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: change y-axis

03 Dec 2012   #1

64 bit
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 System SpecsSystem Spec

03 Dec 2012   #2

Linux Mint 17 Cinnamon | Win 7 Ult x64

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 SpecsSystem Spec

 change y-axis

Thread Tools

Our Sites

Site Links

About Us

Find 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 04:24 PM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33