Hi All,
I joined the forum yesterday.
Attached sample excel file shows data of 10 types of errors made by a team of 10 engineers as pointed out by customer. Two sample column type error graphs shown have been made using normal excel charting process.
Can someone tell me how can I make a Dynamic Interactive Error Graph / Chart in excel 2007 using Scroll or Slider commands such that by moving the Sliders or Scrolls from left to right (For Engineers) and up and down For Errors ) and without using any Macros and complicated commands all possible combinations of engineers (from Mahesh to Deepak ) and errors (Error 1 to Error 10) are covered and the chart gets updated.
Thanks and regards
Aniruddha
Bookmarks