I have a pivotchart for a document I use every work day and we add new data into it everyday. Everytime I refresh data it wipes out my formatting for the labels. Is there any way to set this to remain constant so all I have to do is click refresh data.
