Be Excellent To Each Other

And, you know, party on. Dude.

All times are UTC [ DST ]




Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Graph nerds!
PostPosted: Wed Jul 02, 2014 13:12 
User avatar
Bouncing Hedgehog

Joined: 27th Mar, 2008
Posts: 26076
Hello,

Please can you help?

Lets say I have three sets of data. For simplicity lets use the following three columns of numbers:

12 1200 120
24 2400 360
36 4800 640
64 9600 1200

All numbers in this case. I don't know what they represent - but I want to show the correlation.

So, if I had just the first two sets of data i could use a secondary vertical axis to plot against and the first two data pouints would align perfectly in each set and then start to divrge.

But i want to have a third set of figuires on that. The first point of data should align for each of the three data sets now.

basically, i want the scales to overlay thr three line graphs to show the correlation... how do i get the three scales on there without manipulating the data to (for example0 show column b as 12 (hundred).

_________________
Image


Top
 Profile  
 
 Post subject: Re: Graph nerds!
PostPosted: Wed Jul 02, 2014 13:25 
User avatar
ugvm'er at heart...

Joined: 4th Mar, 2010
Posts: 22392
I don't think you can have 3 vertical scales in excel, let me have a look.


Top
 Profile  
 
 Post subject: Re: Graph nerds!
PostPosted: Wed Jul 02, 2014 13:25 
User avatar
Gogmagog

Joined: 30th Mar, 2008
Posts: 48899
Location: Cheshire
Have a secondary axis, you mean?

EDIT: Learn to read, fucknuts.

_________________
Mr Chris wrote:
MaliA isn't just the best thing on the internet - he's the best thing ever.


Top
 Profile  
 
 Post subject: Re: Graph nerds!
PostPosted: Wed Jul 02, 2014 13:25 
User avatar
EvilTrousers

Joined: 30th Mar, 2008
Posts: 3073
Does this graph help?

Attachment:
rabbuck.jpg


You do not have the required permissions to view the files attached to this post.

_________________
Everyone but Zardoz is better than me at videogames.


Top
 Profile  
 
 Post subject: Re: Graph nerds!
PostPosted: Wed Jul 02, 2014 13:41 
User avatar
Bouncing Hedgehog

Joined: 27th Mar, 2008
Posts: 26076
That is awesome.

I think I may give this up as a lost cause.

stupid graphs.

_________________
Image


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

All times are UTC [ DST ]


Who is online

Users browsing this forum: Columbo, Vogons 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.