• Excel Book Excerpt

Excel Create a Chart with One Click

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

Create a Chart with One Click

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

LE10001022.jpg 

Figure 994 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.

LE10001023.jpg 

Figure 995 Press Alt+F1.

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

Caution: In Excel 2007, if your data includes dates as labels, the upper-left cell of the data range should be blank. Clear out the “Region" heading before using this trick. In Excel 2010, the problem is fixed.

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.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel:

privacy policy