I am needing the 'Series' & 'Point' values of the ToolTip function to be placed into two separate cells as the mouse is hovering over their [url removed, login to view], the values wills be kept in the cells even as the user clicks outside of the chart. There should be a 'reset' button to erase all options in the chart. Keep in mind that there could be more than one chart in the worksheet. Syntax would be something like:
User clicks chart one, series one: Export series 'name' the user clicks to Cell A1 and export the series 'point' the user clicks to cell A2.
User then clicks chart two, series two: Export this series 'name' the user clicks to Cell B1 and export the series 'point' the user clicks to cell B2.
User hits the button 'Reset' to clear all values in cells A1, A2, B1, B2.
I also need where when a user clicks a particular series (in example, piece of a pie or a bar in a bar chart) the rest of the objects in that chart (other pieces of the pie, other bars) will turn light grey. Then the colors will return to normal once you click the 'reset' button as referenced above. Keep in mind that there could be more than one chart in the worksheet.
I would like to keep this project budget friendly as it is a pretty simple syntax. HOWEVER, All bids will be accepted as I need this IMMEDIATELY so time is of the essence.
Please reach out with any questions.