Deleting 0% Pie Chart Labels

[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

 

[Joe Wroblewski]

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

 

[Duane Hookom]

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.

 

[Joe Wroblewski]

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