I have a workbook with multiple worksheets. On one of the worksheets, I want the tooltip to dynamically enter a sheet name and display the line graph on that sheet. Below is the information currently in the tooltip and it points statically to the "Batting Average" worksheet in the attached example:
I want to replace Sheet name="Batting Average" with Sheet name="Measure Names" to dynamically display the line graph from either the Batting Average, Home Runs or Runs Batted In worksheets. Does anyone know how to do such a thing?