Final answer:
To copy a pivot chart without a link, use Copy (Ctrl+C) followed by Paste Special, choosing to paste as an image or 'Values & Source Formatting'. This creates a static chart that won't update with the original data.
Step-by-step explanation:
To copy a pivot chart without a link to the original data in Excel, you can use the Paste Special feature. First, select the pivot chart, right-click and choose 'Copy' or press Ctrl+C. Then, navigate to the desired location where you want to paste the chart, right-click, and select Paste Special. Within the Paste Special options, choose to paste as an image or use the 'Values & Source Formatting' to maintain the visual layout without the data connection. This will create a static chart that does not update or reference the original pivot table data.
Keep in mind that after pasting the pivot chart in this manner, any updates to the original pivot table will not be reflected in the copied chart. This method is useful when you need a static report or visualization that remains unchanged.