Pivot Tables

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

Resolved · Low Priority · Version Standard

Pivot Tables

Tara has attended:
Excel Advanced course

by - delegate Tara [1 post] (2008 Feb 13 Wed, 17:18) Reply

How do I create a pivot table in graphical format?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	4	book now	£475	£485
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Pivot Tables

by - trainer Amanda platinum contributer [961 posts] (2008 Feb 29 Fri, 14:52) Reply

Hi Tara

Thank you for your question; and apologies for the delay in reply.

You can create a PivotChart to display a pivot table in graphical format.

This can be done either when you are going through the PivotTable and PivotChart report wizard (at step 1 select the PivotChart report option); or when you have created the pivot table, you can use a button on the Pivot Table toolbar to create a pivot chart instantly from the pivot table data.

I hope this helps.
Amanda

· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel Training: Not Just for Newbies Anymore
· MS Excel: Excel At Making The Most Of Your Christmas
· How Excel Training Can Improve Your Company's Sales Process
· Benefits of learning about Excel charts

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips