gertrade.blogg.se - How do i make a pie chart in excel 2010

One column with a label, and one column with data that will be displayed as the appropriately sized pieces of the pie. For the optimal display of data in a pie chart, it’s ideal to have two columns. This guide will assume that you already have data in a spreadsheet, and that you wish to display that data as a pie chart. The steps in this article were performed in Microsoft Excel 2013. How to Create a Pie Chart in Excel (Guide with Pictures) Our create table in Excel tutorial can show you how to do this. Our article continues below with additional information on making a piechart in Excel, including pictures of these steps.Īnother thing you can do with your spreadsheet data is turn it into a table. Simply click the empty element and press Delete to get rid of it.Īlthough we created a pie chart, you can insert any number of chart types.4 Additional Sources How to Make Excel 2013 Pie Charts If the legend displays an empty series, you probably didn’t resize the data range (step 5). To format the series, right-click the chart and choose Format Data Series. For instance, you can remove the border or change its style or shade the background. Right-click the chart’s background and choose Format Chart Area from the resulting shortcut menu. With the chart in Word, you can format it. You can save it if you like, but you don’t have to. When you’re done entering the labels and values, close the Excel sheet.Be sure to resize the data range as instructed.

Insert new labels and values in the Excel sheet and watch the chart in the Word document update accordingly.

Click OK and Word will launch an Excel sheet with sample data.

Choose one of the pie charts to the right (we’ll use the first).

Right-click the chart and choose Chart Type to access the different types. (In Word 2003, you’ll select a chart type after inserting the chart into the document.

In the Insert Chart dialog, choose Pie in the left pane.In Word 2003, choose Picture from the Insert menu and then select Chart. Click the Insert tab and then click the Chart option in the Illustrations group.Then, you’re ready to create the chart, as follows: Most likely, that will be before or after a paragraph that discusses the information expressed by the chart. That’s right, you don’t have to be familiar with Excel to display a decent chart in a Word document-and it’s easy!įirst, position the cursor where you want to insert the chart. You can easily add a chart to a Word document, without first creating the chart in Excel. You can bypass Excel and insert a pie chart into a Word document, from inside Word. Add a pie chart to a Word document without opening Excel