Deleting 0% Pie Chart Labels

  • Thread starter Thread starter Joe W
  • Start date Start date
J

Joe W

I have pie charts i'm producing from query data.
I'd like do delete the "0%" that print when the give category has zero
as it's value.
How do I reference this pie chart label?

Thanks
Joe
 
Thanks, that would solve that issue. I didn't give you the full picture.

The other issue I didn't mention is that I want similar pie charts to
have the same colors for the same labels in each pie.
I thought I could achieve that by setting the pie slice colors initially
for each slice and the just not showing the lables for the 0% slices.

Is there some way to color the slices bases on the slice label?

Thank,

JoeW
 
You can set the colors dynamically however you want with code. I am sorry I
don't have the code at hand. You can open any module and set a reference to
the Microsoft Graph library and then open the Object Browser to see all the
methods and properties available to you through VBA. Maybe SteveT will
stumble on this thread and enlighten us.
 
Thanks,

However, I'm not sure I know how to do what you're suggesting. I'll
give it a whirl.

In the meantime ... I await a visit from SteveT.

Thanks again.

Joe W
 
Back
Top