Tips & Tricks‎ > ‎Excel Tips‎ > ‎

Create an Instant Chart

posted Apr 2, 2011, 8:39 AM by Ayush Jain
You can create a chart quickly in Microsoft Excel without having to use the chart button on the toolbar by using these two shortcuts whilst inside a range of data. The chart created is Bar chart which you can change as per your requirement.
Here are the shortcuts:-
  1. ALT + F1: This shortcut creates chart with in worksheet.
  2. F11: This shortcut creates chart in new worksheet of same workbook.


Just select the data range and click ALT+F1 to create an Instant Chart