Make that Chart Quickly!

Summary: Want to create a chart in the quickest way possible? This tip introduces a very simple shortcut key that allows you to create a chart with a single keypress. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Sometimes going through the Chart Wizards seems to take forever. If you want to put a chart into your workbook very quickly, you can follow these two simple steps:

Select the table on which the chart is to be based.
Press F11.

That's it! Excel inserts a new Chart worksheet before the current worksheet, and bases the chart on the data in your table and the default chart type you have set up. At this point you can perform whatever customization you desire on the chart and work with it as normal.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2210) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more.

Check out PivotTables for the Faint of Heart today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Make that Chart Quickly!