Make Excel Charts interactive with sliders, gauge, dials and more
By Ashish MohtaAdding 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:
- Download CX
- Demo : Monthly Resource Demo
- Video Demo: How to use Crystal Xcelcius
- Read more on Office Tips
|
|
  (+3 rating, 1 votes) 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
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… -
Looking for easy dashboard tools. -
@Mike: If you can throw some more details. I would look in further for you -
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. -
@Billy: Does the tool mentioned in the post helps you ?
