Excel graph query....
Excel graph query....
Author
Discussion

Legend83

Original Poster:

10,596 posts

253 months

Tuesday 16th November 2010
quotequote all
Been tasked with setting up a graph showing the relationship between volume and price over time.

So X-axis is years and Y-axis needs to be volume and price (or Y and Z i.e. a vertical axis at both ends of the graph) - is this possible in Excel? Some sort of scatter jobbie?

Or am I limited to X/Y relationships?

Liszt

4,337 posts

301 months

Tuesday 16th November 2010
quotequote all
Could either be a bar chart or line graph. What you have are two series.

JungleJim

2,430 posts

243 months

Tuesday 16th November 2010
quotequote all
plot the data.

right click on one of the series of data (i.e volume) - you get menu. Navigate through to a button that says "secondary axis". Check the button. Voila!

http://office.microsoft.com/en-us/excel-help/add-o...

Legend83

Original Poster:

10,596 posts

253 months

Tuesday 16th November 2010
quotequote all
Yes, sorry being thick. Got it now.

Mods can close this thread.