Excel

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

Resolved · Low Priority · Version 2003

2 posts

ReplyFri 15 Jan 2010, 16:26Delegate Francoise said...

Francoise has attended:
Excel Advanced course

Excel

Can you show pages of a pivot chart?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Thu 18 Mar 2010	Bloomsbury	1		£224	£225
2003	Thu 18 Mar 2010	Limehouse	0	FULL
2007	Mon 22 Mar 2010	Limehouse	3		£224	£225
2003	Tue 23 Mar 2010	Southwark	6		£199	£204
2007	Thu 25 Mar 2010	Rochester (Hoo)	0	FULL
2003	Fri 26 Mar 2010	Limehouse	4		£224	£225
Full Schedule: See all 79 Excel Intermediate course dates. Bookings currently available until 23rd December 2010.

748 posts

ReplyWed 20 Jan 2010, 09:22Trainer Stephen said...

RE: Excel

Hi Francoise

Thank you for your question

Could you please clarify your requirments for me. Do you wish to display a seperate pivot chart for each item in the page fields collection?

Thnaks

Stephen

2 posts

ReplyWed 20 Jan 2010, 10:35Delegate Francoise said...

RE: Excel

Hi Stephen

Yes, I was showed the "show pages" function for the pivot table and I was wondering when you do a graph from a pivot table, do you have the possibility to do the same? I have tried but the function is not showing.

Thank you.

Francoise

748 posts

ReplySun 24 Jan 2010, 14:24Trainer Stephen said...

RE: Excel

Hi Francoise

Thanks for the update.

I have explored this and can't find any straightforward way to solve this problem.
It would be possible to write a macro which would create a chart for each page field value, but that would involve using VBA and would be relatively complex.

Regards

Stephen

Sun 31 Jan 2010: Automatically marked as resolved.

· So Can You Really Sort On Colours In Excel 2007?
· Excel 2010 : A Glance Into The Future
· Prepare for your MOS Certification with MS Excel Courses
· Let Excel look after the pennies, and the pounds will take care of themselves
· A Picture Is Worth A Thousand Words (Or Numbers)

Please browse our web site to find out more about
microsoft excel 2003 vba courses and other Microsoft training courses.

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips