none
How can I create a custom Gauge/Dial/Graph for use in Excel (2003 and up) in VB.NET

    Question

  • I need to create some custom Gauges/Dials or Graphs to display values I have in an excel spreadsheet for use on a dashboard. each of the gages is used multiple times on that dashboard with different parameters (title, limits, etc.).

    My first idea was to create an AcitiveX Component but that does not seem to be possible with VS2010 and VB.NET. Can anyone point me to a starting point or perhaps a howto or an alternate way to create a component that I would find in the Excel Toolbox?

    I'm using VS2010 and the gages should work at least on Excel 2003 and up.

    • Moved by Larcolais Gong Monday, January 10, 2011 5:47 AM (From:.NET Framework Setup)
    Thursday, January 06, 2011 10:16 PM

Answers

  • You need to use a Form control and not and ActiveX component.  When you right click the tool book in an Excel form and clik Additional controls you will see registered OCX files.

     

    You can create an addin in visual Studio and then regisiter the addin.  There are lots articles on how to do this if you do a google search for "visual studio ocx excel form"


    jdweng
    • Proposed as answer by Bruce Song Thursday, January 13, 2011 9:11 AM
    • Marked as answer by Bruce Song Monday, January 24, 2011 10:28 AM
    Monday, January 10, 2011 8:38 AM
  • I recommend you check out Jon Peltier's blog here http://peltiertech.com/WordPress/ , Chandoo's here http://chandoo.org/wp/ , and the Excel Chart blog here http://www.excelcharts.com/blog/posts/.  There are others that are also good, but these three I find to be among the best.  FYI Jon's has nothing on speedometer-types (he finds them to be misleading).

    HTH,

    Eric

    • Proposed as answer by Bruce Song Thursday, January 13, 2011 9:11 AM
    • Marked as answer by Bruce Song Monday, January 24, 2011 10:28 AM
    Monday, January 10, 2011 3:14 PM

All replies

  • What edition of VS 2010 are you using?

    My Premium Edition offers project templates for Excel 2007 and 2010 add-ins under Visual Basic -> Office in the New Project dialog.

    I'm not sure about Excel 2003 compatibility.

     

    Friday, January 07, 2011 2:15 PM
  • I'm using VS 2010 Ultimate and I have the the same templates. I dont think they'll work for XL 2003 but I havn't tried yet. (We still use 2003 at work and I'm using 2010 at home... so that makes it a little difficult.

    Is there a good howto or template on how to create custom graph object with the Project templates in VS2010?

    Friday, January 07, 2011 8:45 PM
  • Hi,

    I think you can consult your question to Office forum.

    Thanks,

    Larcolais


    Larcolais Gong[MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, January 10, 2011 5:47 AM
  • You need to use a Form control and not and ActiveX component.  When you right click the tool book in an Excel form and clik Additional controls you will see registered OCX files.

     

    You can create an addin in visual Studio and then regisiter the addin.  There are lots articles on how to do this if you do a google search for "visual studio ocx excel form"


    jdweng
    • Proposed as answer by Bruce Song Thursday, January 13, 2011 9:11 AM
    • Marked as answer by Bruce Song Monday, January 24, 2011 10:28 AM
    Monday, January 10, 2011 8:38 AM
  • I recommend you check out Jon Peltier's blog here http://peltiertech.com/WordPress/ , Chandoo's here http://chandoo.org/wp/ , and the Excel Chart blog here http://www.excelcharts.com/blog/posts/.  There are others that are also good, but these three I find to be among the best.  FYI Jon's has nothing on speedometer-types (he finds them to be misleading).

    HTH,

    Eric

    • Proposed as answer by Bruce Song Thursday, January 13, 2011 9:11 AM
    • Marked as answer by Bruce Song Monday, January 24, 2011 10:28 AM
    Monday, January 10, 2011 3:14 PM
  • 1. Dials and gauges look pretty, but reputable data visualization experts do not recommend their use.

    2. Why use an ActiveX component? Why not use regular Excel charts?

    3. If the solution will be self-contained within Excel, why not use Excel VBA?

    4. I have a lot of tutorials about VBA Charting in Excel here:

        http://peltiertech.com/Excel/Charts/ChartIndex.html#V


    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services, Inc.
    Peltier Tech Blog

    Saturday, January 15, 2011 4:44 PM