Chart within a chart

[Zach]

I'm trying to get a Bar graph that won't ever change to combine with a Pivot chart. I've attached the file with the charts in question.

I don't even know if it's possible since the Pivot chart will be changing and the Bar graph will be static, but I'd like some feed back as to whether it is possible.

Thanks

Zach

 

[Luke M]

I'd propose creating the chart on your own, rather than using a PivotChart. You can extract the info you need using GETPIVOTDATA, and using a regular chart would give you more flexibility, including being able to combine with the column chart.

 

[Zach]

Thanks Luke I'll try that.

 

[Eric M]

If the regular chart never changes can't you just Copy > Paste Special > Paste as Picture, then resize it to fit into the pivot chart however you would like?