Hide columns without values in a graph

Assamita

Board Regular
Joined
Sep 23, 2011
Messages
130
Hi,

I have a graph like the one below:


It comes from a Pivot table, and when the country is filtered with a Slicer (in this example DE), the other doesn't have values. How can I hide the column without values?

Thank you
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,109,028
Messages
5,526,332
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top