Hi all,
I have built a dynamic stacked bar chart using named named ranges, with data that changes depending on a country that the user selects. I have modified the formatting of my graph (I changed the color of one of the bars, and used a pattern fill).
My problem is that when the graph dynamically changes (when the user selects another country from a drop down list), the formatting goes back to the original one (color and fill).
Is there a way to change the default formatting so that it remains consistent when the data changes dynamically?
I hope I was clear. Any help appreciated.
Bookmarks