In a Hurry? Create an Excel Chart by Pressing Just One Key

Share on LinkedIn Share on Facebook Share on Twitter Share on Google Plus Share this Page

In a Hurry? Create an Excel Chart by Pressing Just One Key

We have all heard the phase that "a picture is worth a thousand words.” A picture tells a story just as well as a large amount of descriptive text. That can also be said of a chart in Excel. That column or pie chart might be more informative then rows and columns worth of numbers.

A fast and easy way to create a chart sheet in Excel, is to select your data to chart (including row and column labels) and press the F11 key. This is a keyboard shortcut to create a chart sheet. The default chart type is a column chart.

If you do not want a column chart, right-click on the chart and choose the command, "Change Chart Type.” There are many chart types to choose from (lines, pies, bars, and others).

If you do not want your chart on a separate sheet, right-click on the chart and choose the command, "Move Chart.” You can move your chart as an object to an existing worksheet.

Once the chart is created, explore the Design and Format Tabs to make changes to styles, layouts, and colors. Have fun and happy charting!

ERC provides Microsoft Excel training for basic, intermediate, and advanced users.

View the Courses


More on these topics: