A
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 & D2
6 B2:B6 is always
populated and contains labels. What I want to do is, when
D2
6 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
embedded. The data for the pie chart comes from a second
sheet using 2 ranges B2:B6 & D2

populated and contains labels. What I want to do is, when
D2

chart but always show the Legend (which is driven by B2:B6)
Many Thanks
Adam