Gauge/dashboard

Hi

I was looking for some help with dashboards,

I wanted to create a dashboard which has a box for Target,
what the sales person actually did
And then the percentage against target, I have been doing this mannually but I was looking of a way to speed up the process.

The best case scenario would be to be able to put the information into the relevant cells and for them to update the guage,

Please have a look at the attached example.

Thanks for your help

That looks like a lot of work, you'd need to have to work out where the arrow went by code?!?!?

Why not use a chart? Have a look on Andy Pope's (master of all things graph related) site here http://www.andypope.info/charts/gauge.htm

If that doesn't meet your need, there are likely others out there, have you visited Chandoo's site? There's a load of dashboard stuff on there

Thanks for that, Will have a look into it.

Have a look at this