Thread: 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 Cheng@discussions.microsoft.com> wrote in message
news:AF70EC3A-1808-492A-A440-FF94EA7F0389@microsoft.com...
>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