Charts in Excel

A diagram is a visual portrayal of information in the two segments and lines. Diagrams are typically used to break down patterns and examples in informational collections. Suppose you have been recording the marketing projections in Excel for as long as three years. Utilizing outlines, you can undoubtedly tell which year had the most deals and which year had the least. You can likewise attract diagrams to analyze set focuses against real accomplishments.

Types of charts:

1. Pie Chart
2. Bar Chart
3. Column chart
4. Line chart
5. Combo Chart

Importance of charts:

• Permits you to picture information graphically.
• It is simpler to break down patterns and examples in the diagrams.
• Simple to decipher contrasted with information in cells.

Step-by-step example of creating charts in Excel

Follow the below steps to create a chart in Excel:

• Select data you want to create the chart.

• Click on the Insert tab.
• Select the type of chart u want to create.

• Or select the icon on the right side of the selected data and select the chart.

Change Chart Type:

Follow the below steps to change the chart type:

• Click on Chart Design
• Click on Change chart Type
• Select the type of chart you want

Before change

After change

Switch Row/Column:

To switch the rows or columns follow the below steps:

• Legend Position
• Click on Switch Row/Column

Before switch

After switch

Legend Position:

Follow the below steps to place the legends:

• Go to Chart Design in Insert chart
• Click on Add chart Element
• Navigate to Legend
• Select where you want to place your legends.

Data Labels:

Use the below steps to place data labels in the chart:

• Go to Chart Design in Insert chart
• Click on Add chart Element
• navigate to Data Labels
• Select where you want to place your Data Labels.