pivot charts
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Pivot Charts

resolvedResolved · High Priority · Version 2007

replyReply Thu 1 May 2008, 20:52Delegate Ben said...

Ben has attended:
Excel Advanced course

Pivot Charts

Can individual Bars be deleted from Pivot Table Charts?

For upcoming training course dates see: Pricing & availability

replyReply Tue 6 May 2008, 10:22Trainer Pete said...

RE: Pivot Charts

Hi Ben, Thanks for the post, in answer to your question, I cannot think off the top of my head of a way to hide an individual bar, however you could always change its formatting to match the background, joking aside, you can hide a data series, by clicking the tick box in its section (apart from the Field button) but I have not found a way to hide an individual bar, I hope that has helped, best regards Pete

 

Please browse our web site to find out more about
excel+course 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


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard