excel+training - Excel charts and graphs

The UK's most regular instructor-led training courses.
Training information: excel+training · Excel in courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel charts and graphs

Geraldine has attended:
Excel Intermediate course

by - delegate Geraldine [2 posts] (2008 Jan 29 Tue, 14:08) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Excel charts and graphs

by - trainer Stephen gold contributer [396 posts] (2008 Feb 10 Sun, 11:02) Edited on 2008 Feb 10 Sun, 11:03 Reply

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

· Customized Financial Excel Courses in London
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Improve Performance Of Your Excel Macros
· How Small Businesses Profit from Outside Excel Training

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

View all Excel hints and tips

Rate this page: