Pictorial representation of information in Excel can effectively communicate visually and attribute in simplifying the message conveyed. In order to enliven your documents and make a successful first impression, illustrations can unimaginably create the magic. Whether you want to add a pie chart or column chart, never doubt on its capacity to make all information clearer and easier at one go. To give a brief interpretation, graphical support indeed plays an important role. It’s no secret why many successful people take the help of charts during presentations, as no data can be termed good as long as it doesn’t communicate what it means.
For example if you are looking at the profit and loss sheet of a model and you want to evaluate it over 5 financial years. It is easier to interpret it graphically instead of making people understand through facts and figures.
For this we have a shortcut for automatic charts generation, the shortcut is:
Alt + F1 - Chart in same page
F11 - Chart in new page
This shortcut can prove to be of great use as it requires minimal data selection. Use this shortcut trick to create charts and help yourself get your work done better and quicker.
Now that you have learnt about Excel Shortcut for Auto Charts, learn the Excel Shortcut to Insert New Sheet and Excel Shortcuts for Comments