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.
Excel for Office 365 Excel for Office 365 for Mac Excel for the web Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 More. Less A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.
Microsoft Office For Mac
Select the data you want to chart.
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.
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
Microsoft Excel For Macbook
- Download our free Office for Mac Quick Starts to get up and running quickly. Tip: To view, you may first need to first download and install the free Adobe Acrobat Reader DC software. Word for Mac Quick Start.
- Modern workplace training. Learn how to get more work done, from anywhere on any device with Office 365 and Windows 10. Discover how industry professionals leverage Microsoft 365 to communicate, collaborate, and improve productivity across the team and organization.