Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot charts

ResolvedVersion 2007

Ben has attended:
Excel Advanced course

Pivot Charts

Can individual Bars be deleted from Pivot Table Charts?

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

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.