Thank you very much. I will doing some more mucking about, but I think you put me on the right track.
On Thursday, June 25, 2015 at 1:33:23 PM UTC-4, Daniel LaLiberte wrote: > > We have a documentation page on dates and times at: > https://developers.google.com/chart/interactive/docs/datesandtimes > > As mentioned on that page, since you are using JSON, you will probably > want to put your dates in a string notation that looks like "Date(2015, 5, > 25)". Note the months are 0-based. > > Your number values are only in a single column, so there is no way to > specify colors associated with series that way. You would have to > structure your data in multiple columns to get a different series for each > column. > > But alternatively, you can assign a color for each value that overrides > the series color, by adding another column that has role: 'style'. See > https://developers.google.com/chart/interactive/docs/roles > > > On Thu, Jun 25, 2015 at 1:00 PM, zub zeb <[email protected] > <javascript:>> wrote: > > Hi Daniel, > > Below is a sample of what I'm pulling when I view source. I can see where > I might be going wrong now though being that I have the date formatted as a > string though. I tried to switch it to date format, but it caused the > chart to fail. I'm trying to sort out that issue now too. I'm guessing > the charts are pretty picky about the format in which they receive their > date values from mySQL. I'm reading up on that now too and trying to use > the information in this thread to sort it out: > http://stackoverflow.com/questions/24929767/mysql-datetime-in-google-chart > > > Anywho... I would appreciate any direction on this one. If you have a > better source, I sure don't mind reading up on how to sort this out. > Thanks. > > var data = new > google.visualization.DataTable({"cols":[{"label":"Date","type":"string"},{"label":"Daily > > Usage","type":"number"}],"rows":[{"c":[{"v":"2012-01-01"},{"v":153}]},{"c":[{"v":"2012-01-02"},{"v":160}]},{"c":[{"v":"2012-01-03"},{"v":179}]},{"c":[{"v":"2012-01-04"},{"v":171}]},{"c":[{"v":"2012-01-05"},{"v":169}]},{"c":[{"v":"2012-01-06"},{"v":196}]},{"c":[{"v":"2012-01-07"},{"v":205}]},{"c":[{"v":"2012-01-08"},{"v":196}]},{"c":[{"v":"2012-01-09"},{"v":202}]},{"c":[{"v":"2012-01-10"},{"v":213}]},{"c":[{"v":"2012-01-11"},{"v":189}]},{"c":[{"v":"2012-01-12"},{"v":214}]},{"c":[{"v":"2012-01-13"},{"v":193}]},{"c":[{"v":"2012-01-14"},{"v":185}]},{"c":[{"v":"2012-01-15"},{"v":204}]},{"c":[{"v":"2012-01-16"},{"v":206}]},{"c":[{"v":"2012-01-17"},{"v":209}]},{"c":[{"v":"2012-01-18"},{"v":212}]},{"c":[{"v":"2012-01-19"},{"v":219}]},{"c":[{"v":"2012-01-20"},{"v":207}]},{"c":[{"v":"2012-01-21"},{"v":196}]},{"c":[{"v":"2012-01-22"},{"v":213}]},{"c":[{"v":"2012-01-23"},{"v":209}]},{"c":[{"v":"2012-01-24"},{"v":215}]},{"c":[{"v":"2012-01-25"},{"v":205}]},{"c":[{"v":"2012-01-26"},{"v":211}]},{"c":[{"v":"2012-01-27"},{"v":205}]},{"c":[{"v":"2012-01-28"},{"v":201}]},{"c":[{"v":"2012-01-29"},{"v":205}]},{"c":[{"v":"2012-01-30"},{"v":212}]},{"c":[{"v":"2012-01-31"},{"v":204}]},{"c":[{"v":"2012-02-01"},{"v":209}]},{"c":[{"v":"2012-02-02"},{"v":202}]},{"c":[{"v":"2012-02-03"},{"v":215}]},{"c":[{"v":"2012-02-04"},{"v":214}]},{"c":[{"v":"2012-02-05"},{"v":187}]},{"c":[{"v":"2012-02-06"},{"v":203}]},{"c":[{"v":"2012-02-07"},{"v":211}]},{"c":[{"v":"2012-02-08"},{"v":216}]},{"c":[{"v":"2012-02-09"},{"v":206}]},{"c":[{"v":"2012-02-10"},{"v":209}]},{"c":[{"v":"2012-02-11"},{"v":195}]},{"c":[{"v":"2012-02-12"},{"v":199}]},{"c":[{"v":"2012-02-13"},{"v":217}]},{"c":[{"v":"2012-02-14"},{"v":209}]},{"c":[{"v":"2012-02-15"},{"v":214}]},{"c":[{"v":"2012-02-16"},{"v":219}]},{"c":[{"v":"2012-02-17"},{"v":219}]},{"c":[{"v":"2012-02-18"},{"v":216}]},{"c":[{"v":"2012-02-19"},{"v":213}]},{"c":[{"v":"2012-02-20"},{"v":204}]},{"c":[{"v":"2012-02-21"},{"v":199}]},{"c":[{"v":"2012-02-22"},{"v":204}]},{"c":[{"v":"2012-02-23"},{"v":195}]},{"c":[{"v":"2012-02-24"},{"v":190}]},{"c":[{"v":"2012-02-25"},{"v":199}]},{"c":[{"v":"2012-02-26"},{"v":211}]},{"c":[{"v":"2012-02-27"},{"v":193}]},{"c":[{"v":"2012-02-28"},{"v":198}]},{"c":[{"v":"2012-02-29"},{"v":202}]},{"c":[{"v":"2012-03-01"},{"v":202}]},{"c":[{"v":"2012-03-02"},{"v":199}]},{"c":[{"v":"2012-03-03"},{"v":223}]},{"c":[{"v":"2012-03-04"},{"v":183}]},{"c":[{"v":"2012-03-05"},{"v":204}]},{"c":[{"v":"2012-03-06"},{"v":204}]},{"c":[{"v":"2012-03-07"},{"v":211}]},{"c":[{"v":"2012-03-08"},{"v":213}]},{"c":[{"v":"2012-03-09"},{"v":194}]},{"c":[{"v":"2012-03-10"},{"v":215}]},{"c":[{"v":"2012-03-11"},{"v":201}]},{"c":[{"v":"2012-03-12"},{"v":211}]},{"c":[{"v":"2012-03-13"},{"v":218}]},{"c":[{"v":"2012-03-14"},{"v":212}]},{"c":[{"v":"2012-03-15"},{"v":210}]},{"c":[{"v":"2012-03-16"},{"v":0}]}]}); > > > > > On Thursday, June 25, 2015 at 9:56:10 AM UTC-4, Daniel LaLiberte wrote: > > Zub zeb, > > Does your DataTable have one column for each of your series? Can you > give an example of what your data looks like, perhaps in the form of an > array of arrays that you could pass to arrayToDataTable? > > > On Wed, Jun 24, 2015 at 5:42 PM, zub zeb <[email protected]> wrote: > > I'm pretty sure I'm supposed to be using the series function for this, but > whenever I try, I get only the first color of the series to display. The > way it's set up now is that it pulls hourly timestamped data from a mySQL > database from one column and then displays the totals of another column for > that 24 hour period. The user can then select the period they want to view > data for in order to view a column chart that covers days, weeks, months, > or even years of data at a time. Chart looks great, but all the days are > the same color, and I would like to be able to have the user identify which > days are the weekends. > > Can anybody point me in the right direction for achieving this? Like I > said, I know I'm supposed to be using a series in order to achieve this, > but haven't had much success. > > I figured something like this should be what I want but like I said, I > only see the first color for ALL the columns: > > series: { > 0: { color: '#99FF66' }, > 1: { color: '#99FF66' }, > 2: { color: '#f1ca3a' }, > 3: { color: '#6f9654' }, > 4: { color: '#1c91c0' }, > 5: { color: '#43459d' }, > 6: { color: '#e7711b' }, > }, > > > > -- > 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 > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/d/optout. > > > > > -- > > ... -- 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 http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
