![how to create pie chart in excel sheet how to create pie chart in excel sheet](https://www.wikihow.com/images/c/ca/Make-a-Pie-Chart-in-Excel-Step-6-preview-Version-2.jpg)
Click on the blank space of the chart area again, go to ‘Design’ tab and find the option ‘Change Colour’ to pick from a selection of colours. The colour and design of the chart can also be easily changed according to your preference.
#HOW TO CREATE PIE CHART IN EXCEL SHEET HOW TO#
Just click on the caption to make it editable and type in your own title.Īnd we’re still not finished here! How to Change Colour and Design of the Chart Of course, you can name your pie chart anything you want. The title of the graph now contains the caption ‘Chart Title’.
![how to create pie chart in excel sheet how to create pie chart in excel sheet](http://www.wikihow.com/images/b/be/Create-a-Graph-Using-a-Spreadsheet-Step-19.jpg)
Let’s move on! How to Add a Chart Title in Excel You can easily adjust the size of the chart, too – simply by clicking into any corner of the chart area, on one of the little circles, and dragging any direction until the size of the chart is just what you need it to be. How to Adjust the Size of a Pie Chart in Excel Click on the blank space within the chart area, hold the left mouse button and move the graph any direction to place it exactly where you need. The position of the chart within the spreadsheet can be adjusted in a very simple way. How to Adjust the Position of the Chart Within the Excel Spreadsheet Now, let’s see what we can do to improve the chart or customise it more to our liking. There are more chart design options to choose from, but for now, we’ll pick the first one.Įxcel will immediately draw the chart and insert it in the spreadsheet. įirst of all, as usual, we need to select the area with the relevant data – the data we want to present in the graph.Ĭlick on the ‘Insert’ tab, go to section ‘Charts’ and select the pie chart option. In this tutorial, we’ll take some time to explore the pie chart, specifically, how to use it to present monthly sales, which you can see in this table.
![how to create pie chart in excel sheet how to create pie chart in excel sheet](https://www.smartsheet.com/sites/default/files/ic-excel-pie-charts-change-value.gif)
In the previous tutorials, we learned how to make a line graph 4 How to Change Colour and Design of the ChartĮxcel offers many different chart types and choosing just the right kind of graph can make your data presentation clear and engaging.