Charts in MS Excel are the visual representation of the data (stored in an Excel sheet. It helps to determine the trends of the data(s) easily and compare between them, especially when you have a large volume of datasets. There are various charts available in Excel like Bar charts, Pie charts, Column charts, Line charts, X Y (Scatter) charts, etc.
Inserting Charts in Excel:
To insert a chart in Excel follow the below steps:
- Insert the data in the spreadsheet. We will take an example of data showing the sales between January – June.
- Select the data(A2:A7, B2: B7).
- Click on the Insert tab on the ribbon.
- Select your desired chart under the Charts. We are inserting the Bar chart.
- Select your desired chart type.
- The chart will be inserted into the worksheet.
A doughnut chart is the same as a pie chart, i.e., it represents the data as part of a whole, where the sum of parts is equal to 100%. The difference between a Doughnut chart and a Pie chart is that multiple datasets can be represented in a doughnut chart but only one dataset can be represented in a pie chart. You can find the doughnut chart under Insert tab》Other charts.
A doughnut chart can be used only when:
- We want to represent multiple datasets on a single chart.
- Each dataset has a maximum of 6-7 data, otherwise, the chart becomes very dense.
- None of the values in the dataset is either zero or negative.
Types of doughnut chart:
- Doughnut: In this chart, the slices are attached together and are not pulled apart.
- Exploded Doughnut: In this, the slices of charts are pulled apart.
Inserting Doughnut chart with Single data series:
Follow the below steps to insert a doughnut chart with single data series:
- Insert the data in the spreadsheet. We will take the example of data showing the sales of apple between January – August.
- Select the data(A2:A9, B2:B9).
- Click on Insert Tab.
- Select your desired Doughnut chart(Doughnut, Exploded doughnut), under the Other charts.
- Your desired chart will be inserted into the spreadsheet.
- Doughnut chart for the above example.
- Exploded Doughnut chart for the above example.
Inserting doughnut chart with two data series):
Follow the below steps to insert a doughnut chart with two data series:
- Insert the data in the spreadsheet. We will take the example of data showing the sales of apple and orange between January – August.
- Select the data(A2:A9, B2:B9, C2:C9).
- Click on Insert Tab.
- Select your desired Doughnut chart(Doughnut, Exploded doughnut), under the Other charts.
- Your desired chart will be inserted into the spreadsheet.
- Doughnut chart for the above example.
- Exploded Doughnut chart for the above example.