Empty Last Value in CSV data causes error

[Ken Burkhalter]

After all the effort to get my charting done with 'certainty' flags controlling the chart line appearance, I have run into restrictions that are leading me to use the 'lineDashStyle" property instead.

To do so I need to create two data columns, one for solid and one for dashed lines for the same data.

Since the solid lines appear in one column for the chart up to the current time, and dashed lines in another column thereafter, my solid column has no entries after the current time and that makes the last data value in the csv file empty.

I am thus getting a "Row x has 10 columns, but must have 11" error comment.

Empty values in anything other than the last column are not a problem.

How do I address this?

[Ken Burkhalter]

On Thursday, December 11, 2014 3:47:05 PM UTC-5, Ken Burkhalter wrote:

Empty values in anything other than the last column are not a problem.

Not sure why, but all of a sudden it seems to be working.  ????

Didn't change anything in the csv file I am aware of, but suddenly the chart is drawing OK now.  {Spooky}

But now I have a new issue.

In order to show different line styles before now() and after now() I broke the data Table, for a given reading, into two columns where one column is the before now data for a temperature, and the other is the data after now.

The csv data was illustrated above and this is the resulting chart...

Unfortunately this approach produces TWO legend entries for the same data plot (the new and old values for the same device temp.

Is there a way to eliminate the redundant entry (in the chart above the old (later) values for the "Dwn" temp (labeled 'cert').

This 2nd legend entry is not needed!

[Sergey Grabkovsky]

You can use the visibleInLegend option on a series. For example, it seems that you want to hide the second series, so your options structure would contain:
series: {

  1: {visibleInLegend: false}

}

--
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 post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.

[Ken Burkhalter]

Sergey -

As usual you just hit a Home Run again.

I spent hours yesterday trying to discover such a method, with no luck.  That does exactly what I wanted.

BTW - If there is a link to a full reference source I could probably answer a lot of these issues myself, but I have only been able to find bits and pieces posted around and snippets of help at various forums.

Thanks again.

 -ken b  [:-)}

[Sergey Grabkovsky]

We have full documentation for each one of our charts. You can find it at https://developers.google.com/chart/interactive/docs/gallery/linechart

[Ken Burkhalter]

Thanks Sergey - That is the best source I have found and have been using it since the beginning of my efforts BUT it is extremely difficult to find information therein.

Unfortunately much of what I try to find, I never can.  :-(

Only when I searched on "visibleInLegend" in the Line Chart gallery entry did I find it buried in the Series Configuration Options.

What would be really, really helpful, I suggest, is to have a full dictionary of all possible config options listed somewhere.  When one is not familiar with what is possible, it is difficult to do myriad searches for things you have no clue as to what they might be called.

With a full list, one can at least do visual searches and let the brain pattern recognize appropriate candidates.    [:-)}
 -ken b

You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/yqK6thg32Ks/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.

-- 
-ken burkhalter

[Sergey Grabkovsky]

What do you mean by "full dictionary of all possible config options"? That seems like exactly the thing that I linked to. Seems like you could always search either the page or the entire Google Charts Developers site for "legend" and find the option like that.

[Ken Burkhalter]

I meant an ordered (alpha) listing by name of all options, formatters, properties, methods, etc applicable to a chart type.  I envisioned just a list with no definitions (perhaps links to applicable knowledge sources).  The more compact the list, the easier to visually search or use Find on to see and compare potential matches.

Especially when one is trying to get started and not at all sure exactly where to look for something, it is very difficult to get to the right place to find the data.

I spent probably three hours yesterday searching the web with every variation of "legend",  "hiding" text strings I could think of and never discovered the "visibleInLegend" approach.
 [:-)}