Excel: Create a Chart with One Click

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: I have to create a bunch of charts based on data I already have in Excel. How can I speed up the process?

  1. Select the data including the headings.

    Strategy: You can create a chart with one keystroke! Select the data, including the headings and row labels and press Alt+F1.

  2. Press Alt+F1.

    The data will be charted as an embedded chart on the current sheet, as shown above.

    Gotcha: This trick is awesome if you need to create clustered column charts with the legend on the right. The odds says that you have to create something else. Use the next topic to change the chart that you get with Alt+F1.

For more resources for Microsoft Excel