I have a query. I have column chart. When I select one of the element of it (Ex. Y axis has month Jan to Dec). When I select one of the month, rest months get invisible. only one month bar column shows. do we have option that if we select any bar , rest should be visible but in deactivated format. As in filter we select any value unavailable shows in Grey background.
1 more query. I Set Reference to chart. it works as desired.
but when I reopen file ( even after saving) , Set Reference rules get vanish. Even If I do some activity ex. applying color to chart , it disabled the Set Reference.
do we have any trick to Set Reference available until I disable it?
I used answer of Avinash. About changing color of deactivated bars, when I use dark color to bars, deactivated bars can be easily identified. so I though we should not spend time on it.
would you please guide me on Set reference available every time. I mean until I disabled it.
