Tips.Net > ExcelTips Home > Charts > Creating Charts > Make that Chart Quickly!
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.
Tip #2210 applies to Microsoft Excel versions: 97 2000 2002 2003
Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.
Check out ExcelTips: Filters and Filtering today!
Fast Answers!
It doesn't matter if you are a beginner or expert, the ExcelTips archives are the fastest way to improve your productivity. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips
Advertise on the
ExcelTips Site