Exclude empty values from line chart

I'm using a linechart where the X-axis are dates and the Y-axis are decimal values. These decimal values are shown as 0,0 on the chart even if they are missing. Setting initial value to "" does not help.

How do I solve this other than setting the initial value to some arbitrary text string, which works but have negative side effects?

Solved Solved
1 4 200
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

Isn't there a way to just have the chart treat non-existing values for what they are?

Nope.

View solution in original post

4 REPLIES 4
Top Labels in this Space