Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
I'm loosing colour when copying charts from excel to word. | Charts and Charting in Excel | |||
Why Excel changes colors of my charts ? | Charts and Charting in Excel | |||
Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
Why will my Excel charts not print in color? | Charts and Charting in Excel |