Paul Wherly

What are Recommended Charts in Microsoft Excel 2013

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

Figure – Excel will recommend charts based on your data selection

  1. Select the data for the chart
  2. Click on the Insert Ribbon
  3. Click on Recommended Charts
  4. Choose one of the charts that Excel suggests
  5. Click OK

The chart appears – magic!

Figure - Recommended chart appears

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!

 

Shelley Fishel

This topic has been taken from my free eBook on Microsoft Excel Core: Advanced 2013 which can be downloaded here:

excel-2013-core-part-ii (1)

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 enquiries@theittrainingsurgery.com – we would love to chat.

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.

More