Exceljet

Quick, clean, and to the point

Duplicate object

Windows shortcut 
CtrlD
Mac shortcut 
D

Use this shortcut to duplicate objects on the worksheet, including charts, shapes, smart art, and text boxes. This is a handy way to maintain consistent formatting across a number of like objects.

Related videos

The videos below demonstrate this shortcut.
In this video, we'll look at how to make an area chart. Like line charts, area charts are a good way to show trends over time.
In this video, we'll look at how to make a 100% stacked area chart. Stacked area charts can show changes in a part-to-whole relationship over time.
In this video, we'll look at how to add additional pivot charts based on the same data. When the data is refreshed, all charts will update at the same time.
In this video, we'll look at how to resize and copy charts, including a way to snap the chart to cells.