Keep format after pivot

C

CG

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Chart Refresh cancels all chart formatting 2
Formatting pivot chart axis labels for dates 10
Pivot Tables and Graphs (charts) 3
Format the x axis of a pivot chart, no number tab??? 1
Pivot chart 1
Can I save format changes to a Pivot Chart? 3
Pivot Table Chart no longer works with Office:MAC 2008 4
Chart size changes with change in data 1

Top