Skip to content Skip to sidebar Skip to footer

Steps To Create Pie Chart In Ms Excel

Pie Chart In Excel

Microsoft Excel is a popular tool used by many people for different purposes, including data analysis and presentation. One of the most common ways of presenting data is through pie charts, which is a visual representation of data in the form of a circle divided into different sections. Creating a pie chart in Excel is a simple process that can be done in just a few steps. In this article, we will discuss the steps to create a pie chart in MS Excel.

Step 1: Enter Data

Excel Data

The first step in creating a pie chart in Excel is to enter the data that you want to present in the chart. Make sure that the data is organized in columns or rows, with each column or row representing a different category. For example, if you want to create a pie chart to show the sales of different products, you should have a column for the product names and another column for the sales figures.

Step 2: Select Data

Select Data For Pie Chart

Once you have entered the data, you need to select the range of cells that you want to include in the pie chart. To do this, click and drag the mouse over the cells that you want to include. You can also use the Ctrl key to select non-contiguous cells.

Step 3: Insert Pie Chart

Insert Pie Chart In Excel

After selecting the data, you need to click on the "Insert" tab and select "Pie" from the chart options. You can choose from different types of pie charts, including 2D or 3D, and with or without labels.

Step 4: Customize Chart

Customize Pie Chart

Once the pie chart is inserted, you can customize it according to your preferences. You can change the colors of the slices, add data labels or a legend, and adjust the size and position of the chart within the worksheet.

Step 5: Save Chart

Save Pie Chart

Finally, you need to save the pie chart in Excel so that you can use it in other documents or presentations. To do this, click on the chart to activate it, and then click on "Save As" under the "File" tab. You can choose to save the chart as an image, PDF, or Excel file.

Conclusion

Creating a pie chart in MS Excel is a straightforward process that can be done in just a few steps. By following the steps outlined in this article, you can create a professional and visually appealing pie chart to present your data. With Excel's customization options, you can personalize the chart to suit your needs and preferences.

Related video of Steps To Create Pie Chart In Ms Excel