Interactive Charts - VBA - URGENT

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.

Beceriler: Excel, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını görün: interactive charts, vba time, excel 2013 vba, colors outside, b2, interactive excel, chart bar chart, vba rest, charts excel, vba function, excel vba interactive chart, rest vba, vba project chart, return time excel, cell excel vba, excel vba cell, chart vba excel, excel vba function, project 2013 export, vba simple project excel, excel mind, bar chart tooltip, excel vba time series, excel chart vba, excel 2013 visual basic

İşveren Hakkında:
( 6 değerlendirme ) PLANO, United States

Proje NO: #4448569



I will send you an excel file in PM.

1 gün içinde 59$ USD
(0 Değerlendirme)

3 freelancers are bidding on average $79 for this job


Expert VBA developer here....I can provide a solution for this.

1 gün içinde 94$ USD
(80 Değerlendirme)

I am ready to start this project.. thanks

1 gün içinde 84$ USD
(0 Değerlendirme)