Hello,
I have this Pivot chart with controls in which I can select different criterias and excels creates charts accordingly. My questions is how can I permanently create formatting of these lines in the chart so that no matter what I select the formatting does not get change. Right now, each time I chose different criterias the line (color, grids, fonts, etc.) gets changed. I appreicate your help a lot. Thanks in advance.
I have this Pivot chart with controls in which I can select different criterias and excels creates charts accordingly. My questions is how can I permanently create formatting of these lines in the chart so that no matter what I select the formatting does not get change. Right now, each time I chose different criterias the line (color, grids, fonts, etc.) gets changed. I appreicate your help a lot. Thanks in advance.