BACKGROUND: I have an interactive chart (Box and Whisker) that trends over time contract performance as rated (Excellent, Above Average, etc...) by the customer. The Box and Whisker plot for each contract period is determined by the ranking is 5 to 10 performance areas. Along with the ranking the customer provides a narrative in each of the 5 to 10 performance areas. Separate charts display each performance area (i.e. Management Performance, Cost Performance, etc.) as an aggregate across all contracts.

PROBLEM: I have mastered the display of the rankings, but I need to take the narrative remarks (i.e. "Excel Forum did a superb job of meeting the challenges presented to them. I would highly recommend them for all your Excel answers.") associated with each ranking, in each performance area and display the narrative when the user hovers of a data point. I have found solutions that provided the series, axis, or data point plotted, but no solutions that provide a link to a separate cell that contains the narrative on hover, click, double click. I am certain that this will require VBA code to accomplish which I am okay with, but by no means would I consider myself a programmer, I know enough to be dangerous.

Any assistance would be greatly appreciated?

Thank you,
Randy