How to use recommended charts
To add a recommended chart, mark the data you want to include in the chart. In general it’s better not to include totals since then the details might be hard do see. Click the “INSERT” tab, instead of manually selecting one of the many charts available in the Charts section click “Recommended Charts”. Excel will analyze your selected data and recommend the best possible charts to visualize it for you. You can click through the various recommended charts to see which one you prefer. In this case I prefer the first column chart so I’ll click OK to insert it into my spreadsheet.
I’ll move the chart by holding down the left mouse button and dragging it to the desired position.