Running total stat graph

[projectaero]

Hello i am wanting to know how i would go about making a running total stat graph.

Basically what i need is this:

I work a certain amount hour, in that period i need to get say 7 stats per hour.
So if i start at 3:00pm and work til 4:00pm i need to be on 7 stats.
So if i am on 7 at this time, the graph would show:

Stats: ||||||||||||||||||||||||| 100
Per hour: |||||||||||||||||||||| 100
Conversion: |||||||||||||||||||| 100

How would this work?
Thanks

[mdmackillop]

Can you post a sample workbook?

[projectaero]

Basically i want a REPT function that does this,
image below i just dont have enough posts to post it

www img179.imageshack.us/img179/5829/statsos.jpg

Where once you reach a certain amount of stats it changes color and goes up as shown above,

[mdmackillop]

You can post a workbook using Manage Attachments in the Go Advanced reply section

[projectaero]

done

[projectaero]

i want it basically to do this:

say someone inputs there times working and they work for hours
i want there to be 25,50,75,100,200% markers and what ever total stats they need it goes up and up

now i have seen on 1 rept sheet that it changed colors when got over 100, maybe it started a new rept i dunno but the bar looked like 1 full bar

[mdmackillop]

This uses conditional formatting. I don't know how many levels you can set.

[projectaero]

hey thanks for the attempt, still not really what i was after, it is in the sense of changing the color.

the biggest thing is if someone was to work 1 hour or 5 hours - the 100% mark would always stay the same. thats the trouble im having atm.

[mdmackillop]

You'll need to be a lot clearer. I don't follow what you're trying to achieve.