$0 Data Point (not Graphed)

Susan Swisher

I have a range of $$ amounts (to graph). One of the points is $0.00M; however, the Graph will not "graph" that point, why? is there a way around it?

I am using a report to Graph is onto a Dashboard (see below)

Paul Newcome

In that case, you can add 0.00001 to the end of the formula you are using to bring the number over. Use the button to decrease the visible decimals to none visible so it still shows as plain zero, and then it should be charted for you.

=[Sheet Summary Field]# + 0.00001

Paul Newcome

It is because the total is zero. How exactly are those numbers being populated?

KPH

Hi

In your example dataset there is 0 in the $0.00M column. 0% on a pie chart will not be displayed as there is nothing to display. If you used a bar chart there would be a gap for the column with 0 in. Would that help?

Susan Swisher

I need to use a PIE chart and want that point to be displayed as 0%. Is that an option?

Susan Swisher

@Paul Newcome the numbers, from the report (shown above) are coming from a Sheet Summary; through a formula; I am just pulling them into a report, so I can graph them.

Paul Newcome

In that case, you can add 0.00001 to the end of the formula you are using to bring the number over. Use the button to decrease the visible decimals to none visible so it still shows as plain zero, and then it should be charted for you.

=[Sheet Summary Field]# + 0.00001

Susan Swisher

this worked PERFECTLY! Thank you, @Paul Newcome

Susan Swisher

It does look a little "wonky" because it can't visually graph a 0%

Paul Newcome

Happy to help. 👍️