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 [email protected]. To post to this group, send email to [email protected]. 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. For more options, visit https://groups.google.com/d/optout.
