What are Recommended Charts in Microsoft Excel 2013
When creating a chart, it is sometimes a challenge to decide which chart type to use. In Excel 2013, you can now get a recommendation and see samples of the charts that Excel thinks fit your data. It is quite useful to see what it looks like before deciding if it is the right one for you.
Let Excel recommend a chart
Figure – Excel will recommend charts based on your data selection
- Select the data for the chart
- Click on the Insert Ribbon
- Click on Recommended Charts
- Choose one of the charts that Excel suggests
- Click OK
The chart appears – magic!
Figure – Recommended chart appears
The chart type selected now appears on the spreadsheet next to the data, ready for a Chart Title or to be reformatted to match your style.
Has this tip helped you? Leave a comment and tell us how – it really is easy!
This topic has been taken from my free eBook on Microsoft Excel Core: Advanced 2013 which can be downloaded here:
To find out more about our training and to discuss your organisation’s learning needs, give us a call on 020 8203 1774 or email us firstname.lastname@example.org – we would love to chat.