http://chandoo.org/forums/topic/new-dash-to-a-dashboard-idea-help-sought Ask Excel and Charting Questions, Muse about Visualizations, Learn and Share - Discussion Forums - Chandoo.org en-US Sun, 19 May 2013 18:26:14 +0000 http://bbpress.org/?v=1.0.1 q http://chandoo.org/forums/search.php http://chandoo.org/forums/topic/new-dash-to-a-dashboard-idea-help-sought#post-2560 Sun, 01 Aug 2010 14:28:06 +0000 Nilesh Karhade 2560@http://chandoo.org/forums/ <p>Hi !<br /> I tried Gauge as per u r reqmnt bt diffrnt color bands (as u say thick, thin...)dont fit in between. finally i landed up on regular simple Gauge.<br /> I knw its not as per u r reqmnt, bt follow this link if u want.</p> <p><a href="http://rapidshare.com/files/410379352/Gauge_for_Trucks.xls" rel="nofollow">http://rapidshare.com/files/410379352/Gauge_for_Trucks.xls</a> </p> http://chandoo.org/forums/topic/new-dash-to-a-dashboard-idea-help-sought#post-2551 Sat, 31 Jul 2010 12:55:14 +0000 Hui 2551@http://chandoo.org/forums/ <p>Have you had a look at:<br /> <a href="http://chandoo.org/wp/2008/09/09/excel-speedometer-chart-download/" rel="nofollow">http://chandoo.org/wp/2008/09/09/excel-speedometer-chart-download/</a><br /> or<br /> <a href="http://peltiertech.com/Excel/Charts/Speedometer.html" rel="nofollow">http://peltiertech.com/Excel/Charts/Speedometer.html</a> </p> http://chandoo.org/forums/topic/new-dash-to-a-dashboard-idea-help-sought#post-2550 Sat, 31 Jul 2010 10:37:42 +0000 Salahblr 2550@http://chandoo.org/forums/ <p>Better than a bar chart is a dial gauge to show variables that are sequentially lower or higher. For example, A transporting company has 93 trucks, of which 87 are available for service, of which 81 are on service of which 60 are running to full capacity. The Dial gauge would show a speedometer dial from zero to 100, within which a thick blue circular band fills up to 93, within which a less thick green band runs up to 87, within which red thin band runs to the 81 mark on the scale and a black needle points to 60. </p> <p>The needle and the circular ribbons to the measure of the scale are drawn using Shapes in Excel 2003 or Smartart in MS Excel 2007. </p> <p>Now the question: How can I set the needle and the block-arcs that makes the thick and thin color circular bands respond to data on a table that contains the numbers mentioned?</p> <p>Any help is well appreciated and I will build and give you a gift with complete code and graphics to use it as an Excel plugin for displaying real-time info on your dash board. </p>