Tuesday, November 1, 2011

Create a Chart in Microsoft Excel with 1 Keystroke

If you want to create a simple column chart in Microsoft Excel, do this:
  • Click anywhere within the data you wish to chart and press the
    F11 key  (function key at the top of your keyboard).
This action works nicely if your data is consecutive with no blank rows
or columns between the data.  If your data is NOT consecutive, you will
need to select the data BEFORE pressing the F11 key.
The chart below is the result of clicking in any cell above and pressing F11.
Click on the chart below to enlarge the chart.

No comments:

Post a Comment