Excel question, adding Y axis to far right border - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 01-31-2008, 01:40 PM   #1 (permalink)
Ultra Techie
 
Join Date: Feb 2006
Posts: 602
Default Excel question, adding Y axis to far right border

Hello,

I have an excel chart, but want the y axis (% reading in this case) to be on the far right axis, not left axis like typically used. How do I do this?

Thanks!
__________________

__________________
-AMD Phenon X2 555
-Gigabyte GA-880GA-UD3H
-Western Digital Caviar RE WD2500YD 250GB 7200 RPM 16MB Cache Serial ATA150
-Patriot Sector 5 DDR3-1333 (4GB)
-Rosewill 500W PSU
leonardmp92 is offline  
Old 01-31-2008, 02:04 PM   #2 (permalink)
Yek
T.F's Resident Cool Guy...
 
Join Date: Aug 2006
Posts: 1,613
Send a message via AIM to Yek Send a message via MSN to Yek Send a message via Yahoo to Yek
Default Re: Excel question, adding Y axis to far right border

There should be a setting in the chart prop's
__________________

Yek is offline  
Old 01-31-2008, 02:20 PM   #3 (permalink)
Ultra Techie
 
Join Date: Feb 2006
Posts: 602
Default Re: Excel question, adding Y axis to far right border

Where pls? Pls walk me thru the steps, I could not find anything except being able to set an axis on the left side, not right side.
__________________
-AMD Phenon X2 555
-Gigabyte GA-880GA-UD3H
-Western Digital Caviar RE WD2500YD 250GB 7200 RPM 16MB Cache Serial ATA150
-Patriot Sector 5 DDR3-1333 (4GB)
-Rosewill 500W PSU
leonardmp92 is offline  
Old 01-31-2008, 09:48 PM   #4 (permalink)
Call me Mak or K
Mod Emeritus
 
KSoD's Avatar
 
Join Date: Sep 2004
Location: C:\
Posts: 35,647
Default Re: Excel question, adding Y axis to far right border

If i am not mistaken dont you have to identify the row or column? If so you would have to do a formula in that row or column to produce the % right? So if that is the case why wouldnt you jsut put that forumula in the column to the left?

If you dont put in the forumla why not just put it in where you want it to generate the info where you want it instead of trying to force the software to do something it cant. Even a google search provides this info....

creating right sided axis in excel - Google Search
__________________
I do not accept support questions via EMail, PM, IM or my G+ page!

Phone: LG Optimus G Pro
Running: Stock JB from LG with Nova Launcher

KSoD is offline  
Old 02-01-2008, 12:06 PM   #5 (permalink)
Yek
T.F's Resident Cool Guy...
 
Join Date: Aug 2006
Posts: 1,613
Send a message via AIM to Yek Send a message via MSN to Yek Send a message via Yahoo to Yek
Default Re: Excel question, adding Y axis to far right border

Chart props was just a guess, personally I don't have a copy of Excel on this machine so I can't check for you. I echo Mak, try a Google search.
Yek is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 bug superdave1984 Microsoft Windows and Software 0 09-26-2007 11:48 AM



Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 06:46 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.