Create a chart in Excel 2016 for Mac

Exploring charts in Excel and finding that the one you pick isn't working well for your data is a thing of the past! Try the Recommended Charts command on the Insert tab to quickly create a chart that's just right for your data.

1. Select the data you want to chart.

   

2. Click the Insert tab, and then do one of the following:

   • Click Recommended Charts and select the chart type you want.

     

     OR

   • Click a specific chart type and select the style you want.

     

3. With the chart selected, click the Chart Design tab to do any of the following:

   • Click Add Chart Element to modify details like the title, labels, and the legend.

     

   • Click Quick Layout to choose from predefined sets of chart elements.

   • Click one of the previews in the style gallery to change the layout or style.

   • Click Switch Row/Column or Select Data to change the data view.

     

   • Click Change Chart type to switch to a different kind of chart.

See Also

Select data for a chart

Structure data for specific types of charts

Format data labels in a chart in Office 2016 for Mac

Add data series in charts