Excel 2013 incudes template charts and pivot tables which are provided by the Recommended Charts and Recommended Pivot Table features. The available options are provided intelligently based on the selected data. Click into or select the data to be pivoted. On the Insert tab, select Recommended Pivot Tables. The dialog box then previews pivot tables … Continue reading Recommended Charts and Pivot Tables
My favourite shortcut in Excel - to draw a chart select the data and press F11 key. Job done.