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