-
Running total stat graph
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
-
Can you post a sample workbook?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
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,
-
You can post a workbook using Manage Attachments in the Go Advanced reply section
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
-
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
-
This uses conditional formatting. I don't know how many levels you can set.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
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.
-
You'll need to be a lot clearer. I don't follow what you're trying to achieve.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules