Author |
Message |
Mimi
|
Post subject: Graph nerds! Posted: Wed Jul 02, 2014 13:12 |
|
|
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).
_________________
|
|
Top |
|
|
Trooper
|
Post subject: Re: Graph nerds! Posted: Wed Jul 02, 2014 13:25 |
|
|
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 |
|
|
MaliA
|
Post subject: Re: Graph nerds! Posted: Wed Jul 02, 2014 13:25 |
|
|
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 |
|
|
Trousers
|
Post subject: Re: Graph nerds! Posted: Wed Jul 02, 2014 13:25 |
|
|
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 |
|
|
Mimi
|
Post subject: Re: Graph nerds! Posted: Wed Jul 02, 2014 13:41 |
|
|
Bouncing Hedgehog |
Joined: 27th Mar, 2008 Posts: 26076
|
That is awesome.
I think I may give this up as a lost cause.
stupid graphs.
_________________
|
|
Top |
|
|