You could create a chart, and export it as a graphic:

'=====================
Sub ExportChartGIF()
ActiveChart.Export Filename:="C:\Data\ExpChart2K.gif", _
FilterName:="GIF"
End Sub
'========================

Then, insert the chart in a comment in the section heading cell. There
are instructions he

http://www.contextures.com/xlcomments02.html#Picture

wrote:
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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html