Hi
Hopeing someone can help - I've looked around on the internet but I could not find anything about moving pivot charts - just moving pivots tables
I'm trying to copy a pivot chart (just the chart) to another workbook so I have the pivot table on one screen and the chart on another. I'm hoping when I change the pivot table via slicers the chart will be linked and update in the other worbook. I was wonderinf if this is possible?
I was going to split the screens so they remain in one workbook but its a bit of a squezze and my chart has to be tiny.
Really hope someone can help!
Many thanks!
Hopeing someone can help - I've looked around on the internet but I could not find anything about moving pivot charts - just moving pivots tables
I'm trying to copy a pivot chart (just the chart) to another workbook so I have the pivot table on one screen and the chart on another. I'm hoping when I change the pivot table via slicers the chart will be linked and update in the other worbook. I was wonderinf if this is possible?
I was going to split the screens so they remain in one workbook but its a bit of a squezze and my chart has to be tiny.
Really hope someone can help!
Many thanks!
