Make Excel Charts interactive with sliders, gauge, dials and more

By Ashish Mohta

Adding Sliders, Gauge and dials can not only give an extraordinary effect to your charts in Microsoft Office excel 2007 or 2003 but they can make them more interactive. Pivottables or Gantt Charts or Dynamic excel chart can be more interactive with them as you will be able to modify the values and see how its going to affect your results. Sounds Confusing right ? Let me explain you more.

What you see is An Application which runs on top of your excel sheet. It contains data from which you wanted to create charts may be pie chart or line chart. Now A user cant do anything more except just seeing the chart on simple excel. Now give a second thought, what if he or she can change the values by just running that slider or nob you see in the picture ? What if he can see the fluctuations on the meter gauge ?

This surely will give him more power to understand how things work or what factors can make his data give a positive result and what can give him red code !!. Even You can create excel chart template, lets say for pareto type and use it every time you have to show to your boss. I am sure he will be impressed. Specially with Microsoft Office 2007 , chart in excel and graph solutions are must for business.

Resources:


Email Print
Vote This Post DownVote This Post Up (+3 rating, 1 votes)
Loading ... Loading ...

About The Author of this article:
Ashish is one of the co-author of this blog and writes on various interesting softwares, PC tips and more. You can read more of his articles here.

Enjoyed this article? Download our Toolbar ( for Free ) and read us more quickly or Free Subscribe to the Full RSS Feed or Get Post like this in your Inbox Free Subscribe via Email


  • Tags: , , ,
  • Read More Stories from Office Tips

  • 5 Comments and Link-Backs to “Make Excel Charts interactive with sliders, gauge, dials and more

    Click Me and Jump to Add your Comment :)

    5 Comments from Friends and Readers

    • Yes i think this is a real good tool for decision makers…

    • Mike, January 5, 2008:

      Looking for easy dashboard tools.

    • Ashish Mohta, January 5, 2008:

      @Mike: If you can throw some more details. I would look in further for you

    • Billy Simon, February 20, 2008:

      I am trying to find away of using excel 2003 to make a “gauge” similar to a fuel gauge on a car. I need this to visually show safety events, quality events and so forth. Basically Green is good, Orange is caution and Red is bad. Can you help.

    • Ashish Mohta, February 20, 2008:

      @Billy: Does the tool mentioned in the post helps you ?

    Leave a comment Share your thoughts with the world

    Scroll Down and Check footer for more details


    • Top Weekly Commentators

      • Jasmine (3)
      • jcidiot (2)
      • Rohok Teyar (2)
      • Eogan (2)
      • JJH (2)

    • Recent Comments:

      • JJH: Or you could just simply go to the “Sounds and Multimedia” dialog in the Control Panel, and change...
      • JJH: TweakUI has the option to do this built-in…. a lot safter than the average Joe editing the Registry. (See...
      • Alina: Hi, If anyone has any more invites, please send one my way. my email is: stephendlim@hotmail(dot)com would...
      • SteveB: I’ve been in the dropbox beta for the past few months, it has been reliable and stable - working in the...
      • fourpx: Hi, I am trying to host a website in my home PC. I do have a static IP, which i bought from BSNL recently....
      • Anurag: Great Tool… Thnx For the post…..
      • CypherHackz: But, is it secure? Nowadayas I keep thinking about the security of the information transfered from my PC...
      • Greg P.: I read up about DropBox on their website. This looks very promising! I especially like the differential sync...
      • dave: I have heard many good things about dropbox and signed up for beta but did not get an invite. May I get an...
      • drew: i want the engage xp theme please how would i get it!!!

    Technology Blogs - Blog Top Sites