Excel graph query....
Discussion
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?
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?
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...
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...
Gassing Station | The Lounge | Top of Page | What's New | My Stuff


