Click the chart that you want to format. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Chart Styles group, click the chart style that you want to use.

You can change the type of chart you think would best represent your data at any time.

1. To change the Clustered Column to Pie, select your chart.
2. On the Chart Design tab, click Change Chart Type > Pie > Pie. Your new chart type will show in your spreadsheet.

Creating Pie of Pie Chart in Excel:

1. In Excel, Click on the Insert tab.
2. Click on the drop-down menu of the pie chart from the list of the charts.
3. Now, select Pie of Pie from that list.

Click anywhere in the chart or click the chart element that you want to change. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Layout tab, do the one or more of the following: In the Labels group, click a layout option for the chart label that you want to change.

Pie chart is a type of circular excel chart which represents the visualization of data in circular format, in this circular chart every category of data has its own part and all the categories make it as a whole circular data, pie chart is a good type of chart for representation but there is a limitation to pie chart …

Open the document containing the data that you’d like to make a pie chart with. Click and drag to highlight all of the cells in the row or column with data that you want included in your pie graph. 3. Click the “Insert” tab at the top of the screen, then click on the pie chart icon, which looks like a pie chart.

The following steps can help you to create a pie of pie or bar of pie chart: 1. Create the data that you want to use as follows: 2. Then select the data range, in this example, highlight cell A2:B9. And then click Insert > Pie > Pie of Pie or Bar of Pie, see screenshot: 3. And you will get the following chart:

In the Format Data Series task pane, on the Series Options tab, select which data can displayed in second pie (in this example, in the second pie we displayed all values less than 10%): You can then make any other adjustments to get the look you desire.

Click Line, click Line with Marker, point to an option and you get a preview of the chart. Click OK, and we have created our line chart. Up next, Customize charts.