Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+training - Excel charts and graphs
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel+training - Excel charts and graphs
Resolved · Low Priority · Version Standard
Reply Tue 29 Jan 2008, 14:08Delegate Geraldine said...
Geraldine has attended:
Excel Intermediate course
Excel charts and graphs
how do i compare two lots of data in one graph if the indices are different - for example, comparing prices of two commodities, oil in US dollars per barrel, and gasoline in Euros per metric tonne?
For upcoming training course dates see: Pricing & availability
RE: Excel charts and graphs
Hi Geraldine
Thank you for your question
This is a case where you might want to use a secondary data axis. This places another axis on the right side of the chart and plots the selected series against that axis, whilst leaving the other series plotted against the primary axis on the left hand side.
Simply right click on the series in question and select series propeties. On the resulting dialog select the axis tab and choose the secondary axis option button.
Hope this is useful
Regards
Stephen
|