Be Excellent To Each Other

And, you know, party on. Dude.

All times are UTC [ DST ]




Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Basic Excel help
PostPosted: Thu Jan 28, 2010 14:31 
User avatar
Excellent Member

Joined: 2nd Apr, 2008
Posts: 3137
Hi

I have the newer version of Excel and all the graphing functions have changed.
Does anyone know simply how to do a graph with dual scales (left and right side axis)

Thanks

_________________
http://Www.Hownotomakeapedal.blogspot.com


Top
 Profile  
 
 Post subject: Re: Basic Excel help
PostPosted: Thu Jan 28, 2010 14:34 
User avatar
baron of techno

Joined: 30th Mar, 2008
Posts: 24136
Location: fife
Curiously enough:
viewtopic.php?style=5&f=3&t=5410


Top
 Profile  
 
 Post subject: Re: Basic Excel help
PostPosted: Thu Jan 28, 2010 14:35 
User avatar
Ticket to Ride World Champion

Joined: 18th Apr, 2008
Posts: 11914
Ha, would love to be able to help, but I have only just got office 2003 installed at work, and I had to beg for that!

Can you not rigt click on the chart line you want on the rhs axis, then select axis tab and separate axis?

_________________
No, it was a giant robot castle!


Top
 Profile  
 
 Post subject: Re: Basic Excel help
PostPosted: Thu Jan 28, 2010 14:36 
User avatar
Excellent Member

Joined: 2nd Apr, 2008
Posts: 3137
Bobbyaro wrote:
Ha, would love to be able to help, but I have only just got office 2003 installed at work, and I had to beg for that!

Can you not rigt click on the chart line you want on the rhs axis, then select axis tab and separate axis?

no not that I can see

I might just use old Excel this is pissing me off :@

_________________
http://Www.Hownotomakeapedal.blogspot.com


Top
 Profile  
 
 Post subject: Re: Basic Excel help
PostPosted: Thu Jan 28, 2010 14:40 
User avatar
Excellent Member

Joined: 2nd Apr, 2008
Posts: 3137
managed it, jesus christ that is so much more complicated than it needs to be

http://office.microsoft.com/en-us/excel ... 51033.aspx

_________________
http://Www.Hownotomakeapedal.blogspot.com


Top
 Profile  
 
 Post subject: Re: Basic Excel help
PostPosted: Thu Jan 28, 2010 14:40 
Bobbyaro wrote:
Ha, would love to be able to help, but I have only just got office 2003 installed at work, and I had to beg for that!

Can you not rigt click on the chart line you want on the rhs axis, then select axis tab and separate axis?


No you can't I just had a look and couldn't figure it out.

I would have expected it to be under the axis button on the menu, but it only seems to be for labelling...


Top
  
 
Display posts from previous:  Sort by  
Reply to topic  [ 6 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: Columbo and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search within this thread:
You are using the 'Ted' forum. Bill doesn't really exist any more. Bogus!
Want to help out with the hosting / advertising costs? That's very nice of you.
Are you on a mobile phone? Try http://beex.co.uk/m/
RIP, Owen. RIP, MrC. RIP, Dimmers.

Powered by a very Grim... version of phpBB © 2000, 2002, 2005, 2007 phpBB Group.