1 Reply Latest reply on Sep 29, 2018 3:51 AM by Chris McClellan

    Dynamically Insert Sheet into Tooltip

    Reginald Jackson

      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:

       

      Year: <Year>

      <Measure Names>: <Measure Values>

      <Sheet name="Batting Average" maxwidth="800" maxheight="400" filter="<Measure Names>">

       

      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?

       

      Thanks.

       

      Reggie