How do I do dashboard charts in Excel
 

I have 3 sets (budget, forecast and actual) of sales and profit numbers and
would like to show them like a dashboard ( two small circles for Budget and
Forecast and a bigger one underneath those two for Actual. All 3 circles with
a hand point to the numbers linked to the source data ). Can anyone tell me
how to make a start?

Thanks and regards

Nick

Hi Nick,

Here are some examples of speedo type gauges.
http://peltiertech.com/Excel/Charts/Speedometer.html
http://www.andypope.info/charts/gauge.htm

Cheers
Andy

Nick Cheng wrote:
I have 3 sets (budget, forecast and actual) of sales and profit numbers and
would like to show them like a dashboard ( two small circles for Budget and
Forecast and a bigger one underneath those two for Actual. All 3 circles with
a hand point to the numbers linked to the source data ). Can anyone tell me
how to make a start?

Thanks and regards

Nick

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

The exceluser.com website has a great how-to manual; ($45) on how to make
really effective dashboard reports. The manual covers how to make small -
readable and updateable charts and tables on a single page, great for
executive level reporting.

I've used many of the techniques to improve my reports and have saved time
developing better reports.

Take a look at the site. It's amazing how you can develop 24 - 30 readable
charts on a single page.

http://www.exceluser.com/dash/startdash.htm



"Nick Cheng" <Nick wrote in message
...
I have 3 sets (budget, forecast and actual) of sales and profit numbers and
would like to show them like a dashboard ( two small circles for Budget
and
Forecast and a bigger one underneath those two for Actual. All 3 circles
with
a hand point to the numbers linked to the source data ). Can anyone tell
me
how to make a start?

Thanks and regards

Nick