View Full Version : [SLEEPER:] Running total stat graph
projectaero
03-26-2010, 04:12 PM
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
03-27-2010, 06:34 AM
Can you post a sample workbook?
projectaero
03-27-2010, 07:04 AM
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
03-27-2010, 07:09 AM
You can post a workbook using Manage Attachments in the Go Advanced reply section
projectaero
03-27-2010, 07:27 AM
done
projectaero
03-27-2010, 07:29 AM
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
03-27-2010, 07:57 AM
This uses conditional formatting. I don't know how many levels you can set.
projectaero
03-27-2010, 09:23 AM
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
03-27-2010, 11:14 AM
You'll need to be a lot clearer. I don't follow what you're trying to achieve.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.