Chart has to change while dashboard changes

[JawaharPrem]

Hi,

in my file while iam change the dashboard, chart should change as data
Ex if i select apr month data change should take april data, if may it should take may's.
i enclosed my excel file format for reference.

Thanks
Jawahar Prem

 

[GraH - Guido]

Like this? It is without macro.

 

[JawaharPrem]

Hi,

Thanks but its not possible in macro, if its please help on same..

 

[GraH - Guido]

Jawahar,

You did not post this in the macro forum, so... I went with a plain Excel solution. VBA is not needed to make it work, therefore I showed an alternative.
But I guess your radio buttons were not working via the macro since they were not grouped.
Good luck with the vba. Others will be glad to help you with it.