Copy Format of a Pivot Chart

[tcalleia]

I have a pivot chart that I perfected and I want to use again but change the values from units to dollars. Simply copying the columns of the pivot table and chart together and pasting elsewhere lets me change the pivot table but the chart is not connected. When I choose select data on the copied chart the "Chart data range" is greyed out. Is there a way to do this?

I'm using Excel 2010.

Thanks so much!

 

[tpbond1]

I would add a unit column to the pivot table. Then either add a new series for units to the existing chart on a secondary y-axis, or create another linked pivot chart and use the existing chart as a template. When you create a pivot chart, you can create from template. So save the one you have formatted as a template and re-use it.

 

[tcalleia]

tpbond1 Thanks for helping me

When I add another series in the table, I can't get rid of it in the chart without also removing it from the table. Not sure if I'm missing something in your explanation?

But... You have opened a new world for me with Chart Templates. I've always just copied charts and changed source data- but that doesn't work for Pivot Charts. Creating a new pivot chart and using a template from the other worked beautifully

Thanks for your help!

 

[Jon Peltier]

Pivot charts are a whole different animal. I wrote a tutorial last year: Working with Pivot Charts in Excel.

To link a pivot chart to a different pivot table requires a few steps.

1. Copy the original pivot chart, and paste it into a different workbook. This unlinks the chart from the pivot table, but still displays the data. But being unlinked, the data is static, and no longer changes when the pivot table changes.

2. Copy this new unlinked chart, and paste it next to the new pivot table.

3. Select the chart, and click the Select Data button on the Chart Tools > Design tab. Click in the Chart Source Data box, then click on the pivot table, then click OK.

Then again, a chart template might be what you need.

 

[tcalleia]

Oh I see- I need to paste into another workbook to break the link- and then back again!

That works beautifully

Jon- Thanks for the step by step instructions and for your blog link