http://chandoo.org/forums/tags/shapes Ask Excel and Charting Questions, Muse about Visualizations, Learn and Share - Discussion Forums - Chandoo.org en-US Thu, 23 May 2013 01:42:46 +0000 http://bbpress.org/?v=1.0.1 q http://chandoo.org/forums/search.php http://chandoo.org/forums/topic/search-box-for-shapes#post-16987 Sun, 22 Jan 2012 14:47:54 +0000 Hui 16987@http://chandoo.org/forums/ <p>Jwplaster<br /> You may also want to have a look at this post:<br /> <a href="http://chandoo.org/wp/2010/12/02/the-selection-pane/" rel="nofollow">http://chandoo.org/wp/2010/12/02/the-selection-pane/</a> </p> http://chandoo.org/forums/topic/search-box-for-shapes#post-16986 Sun, 22 Jan 2012 14:41:53 +0000 jwplaster 16986@http://chandoo.org/forums/ <p>I done it like this.</p> <p>Sub ShapeLookUp()</p> <p>Dim shp As Shape<br /> Dim ShapeName As String</p> <p> ShapeName = InputBox("Shape you are Looking for")</p> <p> For Each shp In ActiveSheet.Shapes<br /> If shp.Name = ShapeName Then<br /> shp.Select </p> <p> End If</p> <p> Next shp</p> <p>End Sub </p> http://chandoo.org/forums/topic/search-box-for-shapes#post-16971 Sat, 21 Jan 2012 13:09:12 +0000 Hui 16971@http://chandoo.org/forums/ <p>Jwplaster</p> <p>Firstly, Welcome to the Chandoo.org forums</p> <p>It's great that you found a solution, but why not post it so others can see your technique used! </p> http://chandoo.org/forums/topic/search-box-for-shapes#post-16969 Sat, 21 Jan 2012 08:13:59 +0000 jwplaster 16969@http://chandoo.org/forums/ <p>Nevermind, figured it out </p> http://chandoo.org/forums/topic/search-box-for-shapes#post-16968 Sat, 21 Jan 2012 05:58:32 +0000 jwplaster 16968@http://chandoo.org/forums/ <p>I need help with a macro for looking up shapes by typing the name of the shape into a search box.</p> <p>This code will find and select the shape.</p> <p>Activesheet.Shapes("nameofshape").Select</p> <p>However, I use hundreds of shapes to represent physical items and need a way to add a text box that I can just type the shape I am looking for and it select it.</p> <p>Thanks </p> 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> http://chandoo.org/forums/topic/drop-shadows-in-cells#post-1010 Wed, 17 Feb 2010 05:16:11 +0000 campingshadow 1010@http://chandoo.org/forums/ <p>Brilliant !!!! I have been scratching my head on this for a long time. Thanks for your response. </p> http://chandoo.org/forums/topic/drop-shadows-in-cells#post-973 Thu, 11 Feb 2010 09:26:08 +0000 Chandoo 973@http://chandoo.org/forums/ <p>Just note that the feature in Excel 2003 is not adding any shadows to cells. It is just adding a shape with shadow. you can drag it anywhere... </p> http://chandoo.org/forums/topic/drop-shadows-in-cells#post-970 Wed, 10 Feb 2010 20:58:30 +0000 oldchippy 970@http://chandoo.org/forums/ <p>Hi,</p> <p>Take a look at Insert &gt; Shapes, then when you draw around a range a whole new tab opens called Drawing Tools where you can then change format, shapes, styles etc. Oooh and also add Shape Effects ie. Shadows &amp; 3D </p> http://chandoo.org/forums/topic/drop-shadows-in-cells#post-969 Wed, 10 Feb 2010 17:42:09 +0000 campingshadow 969@http://chandoo.org/forums/ <p>In Excel 2003 I could select a range of cells and place a box around them with a variety of drop shadow options to give the selection a 3d effect. I have not been able to find out how to do that in either Excel 2007 or the Excel 2010 beta. How is it now done or have they totally removed that option? </p>