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!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s