Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1404
  • Last Modified:

Stacked bar chart - Only show data labels if value not 0

Hi,

Im building a stacked bar chart where the colums are labeled both with value and series name.

I'm searching for a non-vba solution for excluding the series name from the label is the value is 0.  I've attached the chart for reference.

Any ideas?
MPK-Rapport-mock-up-0.3.xlsx
0
decisionfocus
Asked:
decisionfocus
  • 3
1 Solution
 
decisionfocusAuthor Commented:
Thanks for the answer!

However, this removes the data values - i need to exclude the series name as well so that if the data values is 0 neither the series name or the data value is displayed. I've tried to show it in the attached pic.

Br Jonas
Scrshot.jpg
0
 
decisionfocusAuthor Commented:
Or, alternatively, add two different labels to each data series - onw which contains the value and one which contains the series name
0
 
Rgonzo1971Commented:
Hi,

For each serie in your chart you will have to go to Format Data Labels
Label Options: untick Series name
Number:
Custom
Add Format Code "SOK "0;;"" for the SOK Serie

Regards
Copy-of-MPK-Rapport-mock-up-0.3.xlsx
0
 
decisionfocusAuthor Commented:
That did the trick - thanks! Something dynamic would have been stellar, however this works for the purpose!

Br Jonas
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now