i tried to applied data from mysql to Line chat, but there are no values any
one can help???
*google*.*load*("visualization", "1", {
packages : [ "imagelinechart" ]
});
*google*.setOnLoadCallback(*drawChart*);
*function* drawChart() {
*var* data = *new* google.visualization.DataTable();
data.addColumn('string', 'month');
data.addColumn('number', 'Temperature');
data.addColumn('number', 'Humidity');
<%*int* counter = 0;
*try* {%>
<%*while* (db.rs.next()) {%>
data.setValue(<%=counter%>, 0,<%=db.rs.getInt(6)%>+""); // Row 0, column 0
data.setValue(<%=counter%>, 1, <%=db.rs.getFloat(1)%>);
data.setValue(<%=counter%>, 2, <%=db.rs.getFloat(2)%>);
<%counter++;
}
} *catch* (Exception e) {
}%>
On 4/7/09, Doomsday <[email protected]> wrote:
>
>
> Sorry VizBoy but I wasn't very clear on what I wanted. I posted before
> thinking...
> I don't think you can do this as I can not see an option for it in the
> api.
> My x-axis labels for each point are getting very cluttered in my chart
> line.
> Is there a way that I can display a label on the x-axis on every nth
> point.
> So for example only display a date on every 4th point on the x-axis.
> I can hack it by only populating every forth row -> cell 1. But then
> of course I do not get the date in my tooltip for these rows.
>
> Thanks.
>
>
> On Apr 5, 2:33 am, VizBoy <[email protected]> wrote:
> > If you are talking about a linechart then the x-axis is simply labels,
> i.e.,
> > they shouldn't be dates, but rather string values. You can put just "01"
> and
> > "08" in them and no need to put the entire date there..
> >
> > I hope this helps.
> > If not, please clarify/elaborate and i'll try to fruther assist you.
> >
> > - VizBoy.
> >
> > On Thu, Apr 2, 2009 at 8:02 AM, Doomsday <[email protected]>
> wrote:
> >
> > > Hi all,
> > > Ok so I want to make a line chart. The x-axis represents time, for
> > > example weeks.
> >
> > > Along the x-axis you would have:
> > > 01/Jan/2009
> > > 08/Jan/2009
> > > 15/Jan/2009
> > > 22/Jan/2009
> >
> > > This begins to look really cluttered. Is there a way that I can get it
> > > to only display the start of each month.
> >
> > > Is this something that I should implement in my dataTable by only
> > > populating every forth row with a generic month date?
> >
> > > I did have a look at the annotated timeline chart but it looks like
> > > overkill for what I want...
> >
> > > For those familiar with google analytics I want to reproduce something
> > > similar to their charts.
> >
> > > Any suggestions would be appreciated.
> > > Thanks.
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en
-~----------~----~----~----~------~----~------~--~---
