Close the Select Data Source window, to return to the worksheet.In an Excel file, you might have a couple of pivot tables on different worksheets. If you spend time creating a pivot chart for one of those pivot tables, you might want an identical pivot chart for the pivot table. Unfortunately, there's no built-in way to make a copy of a pivot chart, and link it to a different pivot table. Unlike a normal Excel chart, you cannot change data source in a pivot chart. However, if you watch the video below, you'll see a workaround for this problem. Link Pivot Chart to Different Pivot Table The written instructions are below the video, showing how to copy a pivot chart, and connect it to a different pivot table. The written steps below show how to copy a pivot chart, and connect it to a different pivot table.
CANNOT CREATE PIE CHART IN EXCEL 2013 HOW TOĬANNOT CREATE PIE CHART IN EXCEL 2013 HOW TO.
0 kommentar(er)
