Hiding plot Area

[Adam]

I have a formatted output sheet that has a Pie Chart
embedded. The data for the pie chart comes from a second
sheet using 2 ranges B2:B6 & D26 B2:B6 is always
populated and contains labels. What I want to do is, when
D26 contains 0 in each cell (or Null), suppress the Pie
chart but always show the Legend (which is driven by B2:B6)

Many Thanks

Adam

 

[Jon Peltier]

Adam -

All you see of the pie when all values are zero is a single line at the
first slice. The legend still appears. To hide the line, double click on
one of the wedges and on the Patterns tab, change the Border setting to
None. There are no outlines on the pie wedges, but it is the only native
Excel way to hide the line.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______