Thread
:
"Pop-up" charts activated on hover
View Single Post
#
4
August 25th, 2004, 04:51 PM
Tushar Mehta
external usenet poster
Posts: n/a
Nice alternative to something that is otherwise not possible -- at
least not with a hover capability.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
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
Tushar Mehta