Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
KtM
 
Posts: n/a
Default Linking Chart items to files

Anyone got a clue on how to link
each stacked bar(or similar) to a different
file, so when someone views the file, he can
click on the bar, to get a relevant document
on his web-browser/similar(pdf, whatever).
Any suggestions?

  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

You can write event procedures that determine which point was clicked.
Within the procedure you need some kind of lookup to see what document
should be launched according to the point which was clicked.

Here's an article on chart events:

http://www.computorcompanion.com/LPMArticle.asp?ID=221

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


KtM wrote:

Anyone got a clue on how to link
each stacked bar(or similar) to a different
file, so when someone views the file, he can
click on the bar, to get a relevant document
on his web-browser/similar(pdf, whatever).
Any suggestions?

  #3   Report Post  
KtM
 
Posts: n/a
Default

Thank you, looks just like the thing I was looking for.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line chart for churn rates of many items over time Whoops Charts and Charting in Excel 3 August 25th 05 07:26 PM
Chart items moving around Marcus Langell Excel Discussion (Misc queries) 3 August 12th 05 04:10 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Chart Format & Linking? Ken Charts and Charting in Excel 2 January 22nd 05 02:32 PM


All times are GMT +1. The time now is 01:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"