Excel 2016 Charts Tutorial

Learn the basics of excel charts to be able to quickly create graphs for your excel reports.

Excel 2016 charts tutorial. That was a great tool and a great help but excel 2016 offers you something even better. Open our practice workbook. Dont forget to check out our main channel httpswwwyoutube. To create a chart this way first select the data that you want to put into a chart.

Excel 2016 charts c technology training center colorado state university 5 the insert chart window appears with the recommendations for your data. Select a chart on the recommended charts tab to preview the chart. You are able to click on any of the options on the left hand side and see a preview. Select insert recommended charts.

This is under the insert tab on the ribbon in the charts group as pictured above. You can further customize the look and feel of your box and whisker chart by going to chart tools. Include labels and data. If you find a chart that you want either double click on it or select it and hit the ok button.

Select all charts box and whisker ok step 3. Learn how to create different types of charts and graphs such as a clustered columnwe will also show you how to resize the chart change its design and move it to another worksheet or to a new chartsheet. Charts in excel 2016 step 1. Select cells a1e6 and insert a 2d clustered column chart.

Watch the free video here. Change the chart title to september to december sales. In this howtech written tutorial were going to show you how to create charts in excel 2016. Use the switch rowcolumn command.

Highlight your table and go to insert recommended charts step 2. Watch about microsoft excel 2016 video tutorial by simon sez it. Now you have your box and whisker chart. The columns should now be grouped by month with a.

Click the challenge tab in the bottom left of the workbook.