Quick, clean, and to the point

Shortcuts for charts

You can change the default chart type by opening the Chart Type control on the ribbon, selecting a chart type, and clicking the set default button.

This setting controls the default for all new charts in all workbooks.

Note that hen you just randomly select  cell in a set of data, Excel will try to plot all data.

If you only want to plot one series, you can hold down the control key and select just that data. 

Then Excel will only plot the data you've selected.

Once you have a chart, there are a number of shortcuts you can use.

When you select a chart, you can use arrow keys to select various elements in the chart.

The up and down arrow keys will select groups of elements. Groups have names like Chart Area, Plot Area, Legend, and so on. You can see the full list in a drop down on the ribbon.

Once you have a group selected, the left and right arrow keys will select elements in that group.

This is a useful way to select elements in a chart, because it can be difficult to click exactly what you want, especially smaller items.

You can duplicate a chart, or any object, with Control D, and once you have more than one chart, you can use tab to move between them.

Like other objects, you can hold down the Alt key (or command key on a Mac) to snap the chart to the cell grid.

This is a great way to resize and align and multiple charts.

Finally, because charts are objects, so you can use Control + 6 to hide and show all charts.

And don't forget that you can use Control 1 to format any element in a chart.


Related shortcuts

Dave Bruns

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.