Question

Write any two chart types in MS-Excel.

Answer 1

Excel provides you different types of charts that suit your purpose. Based on the type of data, you can create a chart. You can also change the chart type later.

Excel offers the following major chart types −

Column Chart

Line Chart

Pie Chart

Doughnut Chart

Bar Chart

Area Chart

XY (Scatter) Chart

Bubble Chart

Stock Chart

Surface Chart

Radar Chart

Combo Chart

Each of these chart types have sub-types. In this chapter, you will have an overview of the different chart types and get to know the sub-types for each chart type.

Answer 2

• Line Chart: The line chart is one of the most frequently used chart types, typically used to show trends over a period of time. If you need to chart changes over time, consider using a line chart.

• Column Chart: Column charts are typically used to compare several items in a specific range of values. Column charts are ideal if you need to compare a single category of data between individual sub-items, such as, for example, when comparing revenue between regions.