How to highlight SelectedValue in Line chart?

[Akbarov]

Hello community,



I have a line chart with [Date] and average of [Sales].

I want to highlight Selected value in line chart. But right now when I select any value , line chart disapears ( filters only selection ) and only shows selected value.



Can anyone help me?

 

[BSALV]

what do you want ?
You are in your cells with data and you select a cell and in the graph that value has to be highlighted ?
Big stuff in VBA !
Most difficult part is perhaps return to normal as you select another cell.