Dashboard Charting Problem

Darrick Ferrington · 02/27/19

Is there a way to exclude cells that have a zero from charting? The bar chart does not show any data, but the topic headers, that have a zero, are cluttering the legend. If there is no data >0, I really would like the legend to not show the headers.

Paul Newcome · 02/27/19

I generally use an IF statement for this...

IF(original formula > 0, original formula, "")

This says that if the returned result from my formula is greater than zero, display the returned result, otherwise leave blank.

Faye Kennedy · 03/13/21

I did this and the formula worked, but my chart widget in the dashboard is still displaying the blanks. Any ideas?

Dashboard Charting Problem

Comments

Categories