bar chart

[vikranth]

hello friends,

Assume that i have a database with two fields month and sales.

I want to draw a bar chart by taking sales value for each month from the database.

I searched in net but i could not find the necessary help.

Can anyone help me by providing necessary coding or header files or any other information..

thank you in advance.

[bradgrafelman]

How much of this task can you do? Can you retrieve the necessary data from the database?

Also, you're going to have to figure out how you plan on creating these bar charts in the first place - such as by using some external library or class(es). There is of course nothing we can do if you can't at least figure out this much, since the solution is going to be largely based on how the 3rd party tool you've selected is to be used.

One possible choice might be Google's Chart API. I have not personally used this API but have seen it recommended in the past.

[vikranth]

hello bradgrafelman,

ya i know to retrieve the data from database but i dont have any idea about whether to use external library or not.

[DaveRandom]

http://graphpite.sourceforge.net/

You will need the GD extension enabled to do anything like this directly from PHP.

I have just looked at the Google Chart API suggested by bradgrafelman, and it looks like it is probably a little easier to use than graPHPite, but probably less customisable. The other advantage of using Google is that you are using their CPU cycles to build the chart and not your own, but it may be slightly slower, and they might get a bit annoyed if you send them a lot of traffic...