Dynamic, Interactive Charts

[LadyDi]

My department is going "global", and my manager would like graphs created that will display "global" information, but will drill down to the associate level. He explained it to me saying, "it will be like a strategy map". There will need to be an overview chart, that the top level executives will look at. Then clicking on that graph will show supporting data in graphs (by region for example). He would like to be able to continue clicking on the charts to get down to very detailed graphs that would show information by associate. He would also prefer, that everyone not be able to see the raw data behind the charts. How would you recommend accomplishing something like this? My department is on a very tight budget, and we are not able to purchase a new program to do this. We would really like to do it in Excel if that is possible. Any assistance / recommendations you can provide would be greatly appreciated.

 

[VoG]

Hello. That is a pretty general question. What your manager is looking for is called a dashboard. Have a search of the board or Google it and come back with specific questions.