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:
<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?
How do you want to control which sheet is displayed ?
Can you get it all done on a single sheet ?