PHP & MySQL Graph Formula

Question

I've been working on a site that requires a graph to show some data, and the way the data is shown is like this:

I was wondering if anyone knew a correct formula for this graph, along with having the distinct values etc. At the moment I am doing this:

$hitspercent = @round(($hits / $totalinfo) * 100);
$uniquespercent = @round(($uniques / $totalinfo) * 100);

I am trying to make it so the values are rather distinct, so the largest value is at the top of the graph, and smallest is at the bottom, not necessarily half way.

@genesis Read the $ as an S. it struck me as funny for some reason. — Cyclone
– Cyclone, Commented Jul 29, 2011 at 1:04

merodeador · Accepted Answer · 2011-07-29 00:49:53Z

1

nice graph!

actually, i'm doubting what to answer seeing that you have 2 values on each bar, the blue ones ($uniques ?) being quite low.

For one value per bar i'd just use the minimum value of the array as bottom (and maybe add an offset just for design purposes, so that the lowest bar wouldn't have 0 pixels height), something like :

$offset = 5;
$bottom = min($hits / $totalinfo) - $offset;

maybe this tutorial on bar graphs in php is of help, i have it on my bookmarks for an app i'm planning : http://www.qualitycodes.com/tutorial.php?articleid=20&title=How-to-create-bar-graph-in-PHP-with-dynamic-scaling

answered Jul 29, 2011 at 0:49

merodeador

911 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP & MySQL Graph Formula

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related