Hi Group,
Here is my query.
I have created a column chart in an excel and now I want to update it
using a VBA code. I am able to do it but the trouble is, the format,
legends, etc. get changed.
The desired result should be something like this.
Once I select the criterion from the drop-down, only the corresponding
data in the chart should change. Nothing in terms of formatting or
legends or X/Y axis should change.

Kindly suggest a way out.

Regards,
Abhijat