I am attempting to use the Google Chart API to create a data driven bar chart. Below is the example code but i would like to dynamically get the day values so that it displays the last 5 days so if today is Friday it would be as below but on Monday is would be (
The data i know i can get from my SQL query as i have done this previously with a pie chart but i cant seem to get the last five days in this way.
I have seen some controls for similar but they are all in C and i want it in VB.net if possible.
The other tact i have tried is to create variables in the vb.net file containing:
Dim dtmyesterday As String
dtmyesterday = Today.AddDays(-1).ToString
but how do i get this into the code above in asp.net?
alt="Sample chart" id="IMG1" onclick="return IMG1_onclick()" />