I need a llink in a title!

[Luis E Valencia]

Can I make links in the title of a chart?

Or anywhere else??

 

[Alvin Bruney [MVP]]

its relatively easy to determine if this can happen. Set your chart title to
"some<br>test" if it appears on both lines, then yes it can be done
otherwise it can't. If it can be done, add an anchor tag instead of a break
tag

 

[er]

I will do this task (link on the Chart title) in a diffrent way
code start below this lin
----------------------------------
Sub ChartSpace1_SelectionChange(
set c=chartspace1.constant
If ChartSpace1.SelectionType = c.chSelectiontitle Then ' User click on the chart titl
window.open "http://www.itcanbedone.com
end i
end su

 

[Luis E Valencia]

Where can I find more information of how to code charts and pivot tables?

Where should I add this code? Should I define an event eanywhere else??

Thanks

 

[er]

Well,
as you can see from the massive issues via this forum, the OWC documentation is very poor
1st possibility is to post a Q in this forum and hope for the best
2nd is MSDN - If you have a spare time..
3rd - if you have OWC license, you can check for a reasonably help file that normaly is in
"C:\Program Files\Common Files\Microsoft Shared\Web Components\10\1033\OWCVBA10.CHM
other than that , try google
HTH.