2 line graph, need help stopping graph dropping to 0

[Torrie Hughes]

We have data that keeps track of 2 things, one will continue and one will at some point just stop. I would like to stop it from dropping to 0 as shown in the picture attached.

[Daniel LaLiberte]

Hi Torrie,

Have you tried using null values instead of 0? 

On Mon, Nov 11, 2019 at 11:26 AM Torrie Hughes <torrie...@gmail.com> wrote:

We have data that keeps track of 2 things, one will continue and one will at some point just stop. I would like to stop it from dropping to 0 as shown in the picture attached.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/248ea2cb-20e0-47ee-a9f4-6c00800604a8%40googlegroups.com.

--

Daniel LaLiberte

dlaliberte@Google.com   Cambridge MA

[Torrie Hughes]

Doesn't matter if we use 0 or null it still is dropping to 0.

[Daniel LaLiberte]

You'll need to post an example of your chart code and data so we can see what you are doing.  It should work that using null will end the line, except for the possibility of also using the interpolateNulls option, which would instead connect between non-null values by interpolating across the null.  Even so it would not draw zero values.  So I am curious to learn how you are seeing zero values, effectively.

--

You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/6347489b-fd5a-4f95-9d11-eca2724c49c1%40googlegroups.com.

[Torrie Hughes]

This is what Graph looks like in Excel:

This is what it looks like online:

Here is the data that both use:

The yellow space is pretty much repeat values from previous which I think is what you are talking about on interpolating across null, which would explain why those values are dropping to 0.

On Monday, November 11, 2019 at 10:32:28 AM UTC-8, Daniel LaLiberte wrote:

You'll need to post an example of your chart code and data so we can see what you are doing.  It should work that using null will end the line, except for the possibility of also using the interpolateNulls option, which would instead connect between non-null values by interpolating across the null.  Even so it would not draw zero values.  So I am curious to learn how you are seeing zero values, effectively.

On Mon, Nov 11, 2019 at 12:19 PM Torrie Hughes <torrie...@gmail.com> wrote:

Doesn't matter if we use 0 or null it still is dropping to 0.

On Monday, November 11, 2019 at 8:26:11 AM UTC-8, Torrie Hughes wrote:

We have data that keeps track of 2 things, one will continue and one will at some point just stop. I would like to stop it from dropping to 0 as shown in the picture attached.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/6347489b-fd5a-4f95-9d11-eca2724c49c1%40googlegroups.com.

--

Daniel LaLiberte

dlali...@Google.com   Cambridge MA

[Torrie Hughes]

Actually I think the interpolling across NULL is working?

[Daniel LaLiberte]

If you are getting data from a spreadsheet, as it appears, then it may be sending 0 values rather than nulls.   But perhaps you are displaying the chart in the spreadsheet itself, rather than fetching it via the visualization api.  If so, then you are actually using a different chart library, built-in to sheets, so you will have to ask for help in a forum for sheets.

Another thing you can try is to generate a Table chart, which will show what values are being sent to the chart.

On Tue, Nov 19, 2019 at 4:29 PM Torrie Hughes <torrie...@gmail.com> wrote:

Actually I think the interpolling across NULL is working?

On Tuesday, November 19, 2019 at 1:28:01 PM UTC-8, Torrie Hughes wrote:

This is what Graph looks like in Excel:

This is what it looks like online:

Here is the data that both use:

The yellow space is pretty much repeat values from previous which I think is what you are talking about on interpolating across null, which would explain why those values are dropping to 0.

On Monday, November 11, 2019 at 10:32:28 AM UTC-8, Daniel LaLiberte wrote:

You'll need to post an example of your chart code and data so we can see what you are doing.  It should work that using null will end the line, except for the possibility of also using the interpolateNulls option, which would instead connect between non-null values by interpolating across the null.  Even so it would not draw zero values.  So I am curious to learn how you are seeing zero values, effectively.

On Mon, Nov 11, 2019 at 12:19 PM Torrie Hughes <torrie...@gmail.com> wrote:

Doesn't matter if we use 0 or null it still is dropping to 0.

On Monday, November 11, 2019 at 8:26:11 AM UTC-8, Torrie Hughes wrote:

We have data that keeps track of 2 things, one will continue and one will at some point just stop. I would like to stop it from dropping to 0 as shown in the picture attached.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/6347489b-fd5a-4f95-9d11-eca2724c49c1%40googlegroups.com.

--

Daniel LaLiberte

dlali...@Google.com   Cambridge MA

--

You received this message because you are subscribed to the Google Groups "Google Visualization API" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/803eb571-e5d4-4b44-9418-4a4aee85f826%40googlegroups.com.