Quickest Way to Add an Excel Chart
By Allen Wyatt for Excel.Tips.Net
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:
1. Select the table on which the chart is to be based.
2. 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.
This post appears with permission from Allen Wyatt and Excel.Tips.Net.
175 total views, 1 views today