I'm pulling my hair out on this problem.
I would like to show a very simple vertical bar graph which will represent the amount of sales during a week. So the data it would be fed is:
Sunday: 200
Monday : 50
Tue: 500
Wed: 300
Thu: 145
Fri: 0
Sat: 976
This would only be for a single given week, and I want the graph to show the sales data between the days to compare them and see which day had the most number of sales, etc.
Then I'll want two other similar graphs, one for monthly sales, e.g
January: 2000
Feb: 1490
..
December: 4553
And an yearly graph e.g:
2006: 20000
...
2009 30000
Again the comparison will be just between the 7 days of the week, 12 months of the year, or 4-5 years.
I need a url which can be used to create these graphs, where I can just hook in my own data and the rest of the stuff would work by itself. Out of the chart types I'd like to use 'Vertical bar graph' (code bvs).
One thing which can be a problem is the 'encoding' of the graphs, google charts seems to want you to give it an encoding which means a range between 0-500 or 0-6950, but I have no way of knowing which encoding the sales amounts would fall into, they could either be very little sales or very much.