Home » Our Blog » Excel – Create a Chart by pressing one button

Excel – Create a Chart by pressing one button

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:

  1. 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.
  2. Select the entire content table of data to be charted (including row and column headings).
  3. 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.

If you found this post helpful please ‘Like’ us!

Facebook
Facebook
Twitter
Google+
Google+
https://excelatwork.co.nz/2014/03/26/create-a-chart-by-pushing-one-button