View Single Post
  #6  
Old August 29th, 2004, 02:24 PM
Ed Ferrero
external usenet poster
 
Posts: n/a
Default

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