Hi all,

I have a graph which is created using the values from a pivot table in excel 2013. The graph includes many added formats like data labels, colors etc. However every time I filter my data from the pivot the format of the graph goes back to default.

Is there a way to maintain the format of the graph every time with filter the data? I am struggling with this for the last couple of days and cannot find anything helpful on the internet

Thanks in advance