How Do I remove Graph Labels for 0 Values

[Loewen9]

Hi,

I am trying to limit the labeling of the pie chart to non-zero values. Additionally, I only want the headings of the non-zero values shown. Right now, I can either show the non-zero values and no headings (almost perfect), or it shows all the headings even with non-zero values.

The sample pie chart is simplified but designed to replicate a larger dynamic model I am currently updating.


I appreciate your time in helping me solve this problem!

[TMS]

You could change column H to a formula.

Please Login or Register  to view this content.

[TMS]

You could also Format the Data Labels and change the separator to space. Not perfect but, combined with the formula, not far away. You'll still see the shape and the colour associated with the blank label/data. The only way to get rid of it completely is to untick the box in the Select Data | Horizontal Axis Labels.

You could probably do that with a VBA event handler.

[TMS]

Just realised you're using 365, so, better idea. Scrap the previous suggestions. Don't bother with that formula and don't change the separator and no VBA required.

Clear all the current Graph data area and use the (single) formula:

Please Login or Register  to view this content.

That will select the required columns (Name + selected data column) and filter on non zero values.

[Loewen9]

This suggestion is brilliant! Thank you so much!

I really appreciate your time Trevor!

As a side question, do you have any free places you recommend for getting help with VBA code? Not just on for this issue, but in general?

[Loewen9]

I just saw your third comment about one big formula to get the job done.

Which cell do I paste this formula in?

IS there a way for you to post that spreadsheet back with the formula?

[Loewen9]

It actually worked for me the formula you had. Wow, what a great formula!

I will have to review this one to understand exactly how it does it all, but really appreciate the great workaround you found for me!

[TMS]

You're welcome.

Here's the updated file.



If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[TMS]

See: https://www.excelforum.com/excel-pro...materials.html

But Google and this forum (other forums/fora are available, but we don't talk about them) are your friends.