This is a great way to resize and align and multiple charts.įinally, because charts are objects, so you can use Control + 6 to hide and show all charts.Īnd don't forget that you can use Control 1 to format any element in a chart. Like other objects, you can hold down the Alt key (or command key on a Mac) to snap the chart to the cell grid. 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. 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. Once you have a group selected, the left and right arrow keys will select elements in that group. CTRL + SHIFT while dragging icon or file. Toggle or switch to the virtual desktops you’ve created on the Left. You can see the full list in a drop down on the ribbon. Toggle or switch to the virtual desktops you’ve created on the Right. Groups have names like Chart Area, Plot Area, Legend, and so on. The up and down arrow keys will select groups of elements. When you select a chart, you can use arrow keys to select various elements in the chart.

Once you have a chart, there are a number of shortcuts you can use. Then Excel will only plot the data you've selected. If you only want to plot one series, you can hold down the control key and select just that data.

Note that hen you just randomly select cell in a set of data, Excel will try to plot all data. This setting controls the default for all new charts in all workbooks. 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.

Excel shortcut keys chart