Excel help - Honda Motorcycles - FireBlades.org
Off-Topic Discussion of anything that doesn't fit anywhere else. If it's related to motorcycles in any way, DO NOT post it here. Post it in General Discussion or a more specific forum.

User Tag List

 
LinkBack Thread Tools
post #1 of 7 Old 07-21-2006, 2:52 PM Thread Starter
 
phobiaphobe's Avatar
 
Join Date: 05-23-2004
Location: Omnipresent
Age: 37
Posts: 11,499
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 43
                     
Send a message via MSN to phobiaphobe
Excel help

How do I get 2 separate scales on a line graph?

I have one series of numbers going up to about 650, and another series of percentages that correspond with them. How can I get a separate scale on the right side of the graph for the percentages so it doesn't bury the line (by using the large scale) at the bottom?

Tanks.

And then there's this asshole...
phobiaphobe is offline  
Sponsored Links
Advertisement
 
post #2 of 7 Old 07-21-2006, 2:57 PM
 
Hammer's Avatar
 
Join Date: 01-03-2004
Location: INDIANA
Age: 50
Posts: 4,216
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 33
                   
Re: Excel help

Click the separate scale button and set the scale how you want it to read and that should fix it.









I have no idea how to do that.

It's amazing how stupid some people can be.
Hammer is offline  
post #3 of 7 Old 07-21-2006, 3:04 PM
 
RRWANTR's Avatar
 
Join Date: 07-25-2002
Location: Ridgecrest, CA
Age: 75
Posts: 4,668
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 29
             
Re: Excel help

Quote:
Originally Posted by phobiaphobe View Post
How do I get 2 separate scales on a line graph?

I have one series of numbers going up to about 650, and another series of percentages that correspond with them. How can I get a separate scale on the right side of the graph for the percentages so it doesn't bury the line (by using the large scale) at the bottom?

Tanks.

Are you talking about just changing the scale of one axis? If so, after chart is created, right click on axis and select Format Axis and go to the scale tab

04 600RR
RRWANTR is offline  
Sponsored Links
Advertisement
 
post #4 of 7 Old 07-21-2006, 3:06 PM
 
sheepofblue's Avatar
 
Join Date: 07-12-2004
Location: Huntsville AL
Posts: 14,224
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 48
                     
Send a message via AIM to sheepofblue
Re: Excel help

In help type Add a Secondary Axis I think this is what you are trying for.

Must obey the sheep dog
sheepofblue is offline  
post #5 of 7 Old 07-21-2006, 3:12 PM Thread Starter
 
phobiaphobe's Avatar
 
Join Date: 05-23-2004
Location: Omnipresent
Age: 37
Posts: 11,499
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 43
                     
Send a message via MSN to phobiaphobe
Re: Excel help

Worked. Thanks.

And then there's this asshole...
phobiaphobe is offline  
post #6 of 7 Old 07-21-2006, 8:09 PM
 
sheepofblue's Avatar
 
Join Date: 07-12-2004
Location: Huntsville AL
Posts: 14,224
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 48
                     
Send a message via AIM to sheepofblue
Re: Excel help

Quote:
Originally Posted by phobiaphobe View Post
Worked. Thanks.
The fee is you have to show at Grattan again next year

Must obey the sheep dog
sheepofblue is offline  
post #7 of 7 Old 07-21-2006, 9:19 PM
 
seamus's Avatar
 
Join Date: 09-07-2004
Location: Nowhere
Posts: 2,704
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 31
                   
Re: Excel help

Quote:
Originally Posted by sheepofblue View Post
The fee is you have to show at Grattan again next year
With maple.
seamus is offline  
Reply

  Lower Navigation
Go Back   Honda Motorcycles - FireBlades.org > Other > Off-Topic

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the Honda Motorcycles - FireBlades.org forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
A valid e-mail address is REQUIRED. You will not have access to any site features until you activate your account using the activation e-mail that is sent to this address.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page



Similar Threads
Thread Thread Starter Forum Replies Last Post
Quick Excel Question tigerblade Off-Topic 13 07-15-2005 1:59 PM
Needed: MS Excel Savant tigerblade Off-Topic 16 02-12-2005 5:26 PM
excel showmethebombs Off-Topic 5 07-02-2004 9:00 AM
HELP HELP! Bike idling poor and stalling WhooHoo Honda FireBlade 11 04-20-2004 8:21 PM

Posting Rules  
You may post new threads
You may 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 Off
Pingbacks are Off
Refbacks are Off

 
For the best viewing experience please update your browser to Google Chrome