View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pgarcia pgarcia is offline
external usenet poster
 
Posts: 304
Default Bar graph with pop-up box or hyper-link

I'm being asked if this is possible. I have a bar graph with dollar amounts.
The graph takes it's data on a different tab. In cell A1 is the batch number
(e.g. 1MLCLSPTCH040108), B1 is the dollar amount and C1 is Batch/Receipt
Status (e.g. Warning). Is there a VB code that will do the following:
1) If hovering over the bar, it will display the dollar amount but also show
the two adjacent cell data next to it?
or
2) Click on the bar and hyper-link to the cell that the data is coming from?

Thanks