Excel charts when i mouse over a cell
Folks,
This is the situation. I have two worksheets,
sheet 1 is called WA
sheet 2 is called CA
now CA is basically a summary sheet where all values are referenced off WA
and i need graphs to display in CA based on values of WA. The graphs must be
such that when i click on a certain cell, a certain graph pops up. and once i
click some cell, the previous graph hides itself and considering the newly
clicked cell, either nothing happens or a different graph pops up as the case
may be.
I had tried this mouse over graph thingy based on a solution that I had
gotten here but the thing is it was all in one worksheets. And there were 14
graphs in that one sample.
I have 36 graphs to display.
I would appreciate any help in this. I am seriously stuck regarding this.
Thanks,
|