Tag Archives: thresholds

Hidding data labels in a graph

Hello there!

Today let’s talk about how to display only specific values for data labels in graphs.

Let’s go!

1. Create a new report with Year and Cost using Web:

pic1

2. Switch to graph:

pic1

3. Run your report. Go to Data->Advance Threshold Editor:

pic1

4. Create a new Threshold for Cost using Year = 2010:

pic1

5. Click on Cell formatting… (pic1)button. Format the number to Custom and use this value:

“[>0] ”

You have to type a space after the square brackets and remove the double “. So, if must be something like this

[>0]            <- Remove to type 1 space after everything

pic1

6. Apply the threshold. Now you won’t see the data label for 2010.

pic1

That’s it.

Hope it helps!

 

God bless you!

Icons!

Hello there!

Today… A quick tip!

Do you ever needed a good icon to set as your threshold and you didn’t know where to find it?

I always use  https://www.iconfinder.com/  to search for good icons. There are a lot of free and premium, if you want to buy.

That’s it. If you use other website to search for icons, please share in the comments below!

Hope it helps.

God bless you.