Creating charts has never been a one-step process, but we’ve made it easier to complete all of the steps in Excel 2013. Get started with a chart that’s recommended for your data, and then finalize it in another few steps so your chart looks professional and has all the details you want to show.
Use a SmartArt graphic to create an organization chart in Excel, Outlook, PowerPoint, or Word to show the reporting relationships in an organization, such as department managers and non-management employees.
Select Insert > Chart > Pie and then pick the pie chart you want to add to your slide. In the spreadsheet that appears, replace the placeholder data with your own information.
Create a Pareto graph in Office 2016 to display data sorted into frequencies for further analysis. Pareto charts are especially effective in analyzing data with many causes and are often used in quality control.
Create a PivotChart based on complex data that has text entries and values, or existing PivotTable data, and learn how Excel can recommend a PivotChart for your data.
Open Excel. From the Home tab, select the Copilot button. Make sure to format your data in a table or supported range. Ask Copilot to create the kind of chart you want. You can copy and paste one of the example prompts, or type something in your own words. Copilot generates a chart.
How to create a histogram chart in Excel that shows frequency generated from two types of data (data to analyze and data that represents intervals to measure frequency).
