Quick Links ▼

Bookmark page

Printable version

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

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

	98.1 % recommend us
	More live stats...

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

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Pivotcharts

Resolved · Low Priority · Version 2002/XP

Reply Fri 27 Mar 2009, 16:03Delegate James said...

James has attended:
Excel VBA Advanced course

Pivotcharts

How can you reset a pivochart back to show all items in all fields to be visible?

For upcoming training course dates see: Pricing & availability

Reply Fri 17 Apr 2009, 10:14Trainer Stephen said...

RE: pivotcharts

Hi james

Thank you for your question

First let me apologise for the delay in responding to your post.

If you still require an answer to your question, could you please clarify what you are trying to achieve. In particular do you wish to unhide all items in both series and categories automatically?

Thanks

Stephen

Reply Thu 14 May 2009, 09:46Trainer Rich said...

RE: pivotcharts

Hi James,

This question has now been left unattended for a while.

We like to keep down the large number of active forum posts we receive.

As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).

We look forward to hearing from you.

Thank you.
Regards, Rich

Wed 20 May 2009: Automatically marked as resolved.

Excel articles

· How To Create A Simple Currency Convertor In Excel 2010
· More Tips From Excel's Rarely Used File
· How To Split A Stacked Chart In Excel
· A Blinking Good Excel Tip
· What Is A Sparkline And How Do They Work?

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

Excel tip:

Rotating Text in an Excel 2010 Worksheet

Maybe you want to draw attention to certain text or you just simply want to make your worksheet look more exciting!

One of the things you might consider is, rotating the text in a particular cell or set of cells.

1) Select a cell you would like to rotate
2) Click the ''Home'' tab in the Ribbon
3) Click ''orientation'' in the ''Alignment'' section
4) A pop up menu will appear with a few choices, if you want to decide yourself how many degrees to rotate the text, then click ''Format Cell Alignment.''

View all Excel hints and tips