Sitemap

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Excel

Resolved · Low Priority · Version 2003

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

Excel

Can you show pages of a pivot chart?

For upcoming training course dates see: Pricing & availability

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

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

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.

Excel articles

· A Quick Guide To Conditional Formatting In Excel 2007/2010
· Edit Anywhere With Mobile Spreadsheets
· How To Create A Data Table In Excel 2010
· How To Print Worksheets In Excel
· An Introduction To Financial Functions In Excel 2010

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

Excel tip:

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

View all Excel hints and tips

Is there a quick way to change the second image on a roll over without having to upload both images from scratch/ thanks.