Excel – Create a Chart by pressing one button


Posted: March 26, 2014

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 – shortcut to quickly create a 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.

Was this blog helpful? Let us know in the Comments below.

If you enjoyed this post check out the related posts below.

Join our free insiders Group!

Learn how to SAVE TIME and WORK SMARTER, without the 'techie' speak!

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Join our free insiders club! 

Receive 100+ Steps to Becoming Proficient in Excel

>