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
droidus

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
TanyaC

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

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

 change y-axis




Thread Tools





Similar help and support threads
Thread Forum
how do you add the horizontal axis labels to a scatterplot when the 'e
how do you add the horizontal axis labels to a scatterplot when the 'edit' button is blanked out?
Microsoft Office
How do I see the X axis values with Excel 2010
Hi, I know it's a basic question -- and I've been charting with Excel for a while; but now all of a sudden when I make a Line Chart with Excel 2010; the horizonital values shown are just sequential numbers of the real X values. How do I get Excel to show the actual X values on the horizonital...
Microsoft Office
Controller axis mess up. Need Help.
I bought this gamepad (it looks EXACTLY like an xbox controller) a while ago but never felt I needed to try it, until now. So I plugged it in and everything was going well until I realised that my left analog sticks axis's were messed up. So moving forward required me moving the analog stick right,...
Gaming
how to run axis & allies on win 7 ??????
Hi! I have the original axis & allies game cd. it installed fine. my system is: win 7, 64 bit 4gb ram 1tb hdd i5 750 powercolor 5750 1gb
Gaming
Excel - Format Axis - Angle greyed out!?
I made a simple chart plotting economic data from 1960 to present using the year on the time axis. I want to angle the text on a 45 incline for readability. The Custom angle is greyed out. I can choose the Text Direction (Horizontal, Stacked, Rotate 90 degrees, Rotate 270 degrees) but I want...
Microsoft Office
Joystick axis for Halo ce
I tried to set up my joystick for Halo ce, but for the control stick that controls your character, it doesn't let me go up or down. It only lets me go left and right. The joystick controller is a Powerwave PC game controller. Can anyone help? And also the camera stick that controls the camera can...
Gaming

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 16:12.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App