PROBLEM: Creating charts. Need I say more??
SOLUTION: Learn the shortcut key that will allow you to create a charThis tip will make life a little easier for you.
Excel 2010, 2013 & 2016 – Quickly create a Clustered Column Chart
Hard to believe isn’t it. Can Charting really be this simple? You’ll love this feature.
To quickly create the Chart:
- First check the data you want to chart is in a format suitable for creating a Column Chart, i.e. no empty rows or columns.
- Select the entire content table of data to be charted (including row and column headings).
- Press F11.
Note: If you want to move the chart into a worksheet select the chart and then go to the Design tab and select Move Chart. Select the required location and then click OK.