Hi Ion, You'll need to do a couple things, but the first is probably enough. Add to your options: hAxis: { viewWindow: { max: 5 } }. 5 is the index of the next row after the last day with data. If you don't know which row that is going to be, then consider the next thing: change your date column from strings to dates (using the format option in sheets), and then you can specify the viewWindow.max with today's date.
Finally, to avoid drawing dots or connecting lines for any non values, no matter where they might show up, make sure you are specifying null, undefined, or NaN values rather than strings, event empty strings, since an empty string is treated as a 0 value. This won't hide all the trailing rows that have no data, however. For that, you will still need the above. It would be easier for us to help you if you could show us the actual code you are using, including the data and options. Can you point us at your web page? Here is a jsfiddle showing how these various special values behave: https://jsfiddle.net/dlaliberte/tkzhgfu7/ On Fri, Oct 27, 2017 at 10:45 AM, Ion Luc <islu...@axway.com> wrote: > Hello everyone, > > I have the following question: what is a way to have a stacked area chart > only show the non-zero values? > > Below it's the table I'm using ( the cells that display #N/A have the > formula: =NA(), but also tried with other values 0, EMPTY ) > > Date Closed (SP) Open (SP) > 17-09-27 0 293 > 17-10-04 10 371 > 17-10-11 18 415 > 17-10-18 18 435 > 17-10-25 55 404 > 17-11-01 #N/A #N/A > 17-11-08 #N/A #N/A > 17-11-15 #N/A #N/A > 17-11-22 #N/A #N/A > 17-11-29 #N/A #N/A > 17-12-06 #N/A #N/A > 17-12-13 #N/A #N/A > 17-12-20 #N/A #N/A > 17-12-27 #N/A #N/A > 18-01-03 #N/A #N/A > And the chart displays as below: > > > <https://lh3.googleusercontent.com/-qqNum4YdviM/WfNFV0wWdzI/AAAAAAAAAA8/xD5roG1U45YINSln-cKssB9UXO3Loll5gCLcBGAs/s1600/17Q4.PNG> > I would like that the values shown *stop at 17-10-25* (which is the > current date) and use this chart to generate a trendline that would show > where we can get at by 18-01-03. > > Thank you, > Ion Luc > > -- > 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+unsubscr...@googlegroups.com. > To post to this group, send email to google-visualization-api@ > googlegroups.com. > Visit this group at https://groups.google.com/ > group/google-visualization-api. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/google-visualization-api/529c6c3a-0d2e-42f0-9c59- > bbd9ca4855e1%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/529c6c3a-0d2e-42f0-9c59-bbd9ca4855e1%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> dlalibe...@google.com <dlalibe...@google.com> 5CC, 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-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJNPOewbDQjsM2fGFUxyC6wFTzAGgjPb0OebUr%2BkXDtGfQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.