Hi Michael,
A similar solution to that proposed by Tushar Mehta can be found at
http://edferrero.m6.net/Content/ChartSelector.zip
This uses the sheet selection change event, but takes the approach
of changing the chart series rather than changing the visibility
of many pre-determined charts.
Ed Ferrero
http://edferrero.m6.net
wrote in message
om...
I'd like to have charts pop up when the user hovers over the source
data.
For instance, I have several sections of sales data in this form:
Jan Feb Mar Q1 Apr May ...
US
Target 5 6 ...
Actual 6 5
Forecast 5.5 5
Europe
Target 4 5 ...
Actual 4 5
Forecast 5 6
So, when the user hovers over the US or Europe "sections," which would
be the label row plus three following rows (tgt, act, fcst), a chart
of the data pops up to illustrate the numbers. I don't want to take
up room permanently displaying the charts, but want them accessible.
All help appreciated.
Michael Lambert