Is there a way to maintain a chart's format after you change the data
you are looking at? I build a pivot chart and whenever I pivot to view
different data, the chart type reverts from a line -2 axis (which I
selected) back to a bar graph.

Thanks in advance

CG