Question

Different types of charts which can be prepared using Excel?

Answer 1

The main types of charts that can be prepared using Excel include:

1. Column Chart:
   • It displays data changes vertically using rectangular bars, with categories on the horizontal axis and values on the vertical axis.
   • It is primarily used for comparing data variations among different items or tracking trends over a period of time.
2. Bar Chart:
   • It is the horizontal version of a column chart, where categories are arranged vertically, and values are displayed horizontally.
   • It is best suited for comparing multiple items when category labels are long or when emphasising duration or rank.
3. Line Chart:
   • It plots individual data points at regular intervals connected by continuous straight lines [1. Column Chart].
   • It is specifically designed to display continuous trends, patterns, and fluctuations over an evenly spaced timeline (such as days, months, or years) [1. Column Chart, 2. Bar Chart].
4. Pie Chart:
   • It represents a single data series as proportional slices of a circle, where the complete circle equals 100% [2. Pie Chart].
   • It is strictly used to illustrate part-to-whole relationships and market distributions, ideally limited to a maximum of 5 to 7 categories [c. Seven, 2. Pie Chart].
5. Doughnut Chart:
   • It is visually comparable to a pie chart but features a hollow centre and can contain more than one data series.
   • It displays information in nested, concentric rings, where each individual ring represents a completely separate data series.
6. Area Chart:
   • It is structured like a line chart, but the area beneath the data lines is filled with colour or shading [What are the differences between the Area, XY chart and doughnut?]. 
   • It is used to emphasise the magnitude of change over time and to draw attention to the total volume or scale of a trend [What are the differences between the Area, XY chart and doughnut?].
7. XY (Scatter) Chart:
   • It displays data as individual dots scattered across a coordinate grid without connecting lines [What are the differences between the Area, XY chart and doughnut?].
   • It uses two numerical axes simultaneously (Value X and Value Y) to show correlations, relationships, or scientific data patterns between two sets of numbers [What are the differences between the Area, XY chart and doughnut?].