ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Digital Dashboard Graph in excel? (https://www.excelbanter.com/charts-charting-excel/143203-digital-dashboard-graph-excel.html)

Apidej

Digital Dashboard Graph in excel?
 
Are there any way I can make graph in excel that resembled digital dashboard
to show performance data.

Andy Pope

Digital Dashboard Graph in excel?
 
Hi,

I guess it depends what you mean by digital dashboard.

Here are some links to dashboard style charts
http://peltiertech.com/Excel/Charts/SpeedometerXP.html
http://www.andypope.info/charts/gauge.htm
http://www.exceluser.com/dash/index.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Apidej" wrote in message
...
Are there any way I can make graph in excel that resembled digital
dashboard
to show performance data.



Jon Peltier

Digital Dashboard Graph in excel?
 
Stephen Few
(http://www.perceptualedge.com/articl...ard_design.pdf)
defines a dashboard as

"A dashboard is a visual display of the most important information needed to
achieve one or more objectives, consolidated and arranged on a single screen
so the information can be monitored at a glance."

Keep in mind that the gauge-like charts in Andy's first two links are very
inefficient, and go against the above definition. (I created my version as a
hoot, to show an interesting style of combination chart, and it has drawn
inordinate attention.) They take up a lot of room to show very few pieces of
information, at one point in time. If all you did was use a line chart, you
could show the same few pieces of information over a period of time, thus
showing trends as well as one-time values.

Stephen Few (http://www.perceptualedge.com) and Charley Kyd
(http://www.exceluser.com) show effective approaches to displaying data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Andy Pope" wrote in message
...
Hi,

I guess it depends what you mean by digital dashboard.

Here are some links to dashboard style charts
http://peltiertech.com/Excel/Charts/SpeedometerXP.html
http://www.andypope.info/charts/gauge.htm
http://www.exceluser.com/dash/index.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Apidej" wrote in message
...
Are there any way I can make graph in excel that resembled digital
dashboard
to show performance data.






All times are GMT +1. The time now is 08:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com