Accountancy: Class 12 (Part 1) — Chapter 4: Graphs and Charts for Business Data

A graph is a pictorial representation of data showing at least a two-dimensional relationship using axes:

• X-axis: The horizontal axis, usually representing independent categories.
• Y-axis: The vertical axis, usually representing dependent values.

Common types of visual representations include:

• Line Graph: Can be single-line or multiple-line (using different colors/shades for clarity).
• Pie Chart: Represents multiple sub-groups of a single variable.
• Bar Diagram: Depicts and compares two or more variables.

1. Step 1 (Data Entry): Enter the accounting or sales data into a worksheet with proper row and column headers.
2. Step 2a (Selection): Select the specific data range to be plotted (e.g., product-wise totals).
3. Step 2b (Insertion): Go to the Insert tab on the Ribbon, navigate to the Charts group, and select the desired chart type (e.g., Bar, Line, Pie).

Understanding chart elements is essential for effective formatting and customization:

1. Chart Area: The entire chart window including all of its elements.
2. Plot Area: The area bounded by the axes (X and Y for 2D charts; X, Y, and Z for 3D charts).
3. Data Points: Individual values plotted in the chart, represented by data markers (bars, lines, columns, or pie slices). A collection of related data points forms a data series.
4. Axes: The horizontal category axis (X-axis) and vertical value axis (Y-axis).
5. Legend: An index or key that identifies the data series or categories.
6. Chart and Axes Titles: Descriptive text labels for the chart and its individual axes.
7. Data Labels: Labels that provide additional details about individual data markers.

The Design tab allows users to change the overall look of the chart:

• Change the chart type, layout, or style.
• Swap data axes using the Switch Row/Column command (e.g., changing the X-axis from products to quarters).

The Format tab provides options to customize individual elements:

• Shape Styles: Modify Shape Fill (solid colors, gradients, textures, or pictures), Shape Outline (color, weight, dashed lines), and Shape Effects (bevel, shadow, reflection).
• Text Formatting: Apply standard font formatting or WordArt Styles (text fill, outline, shadow, 3D effects).

The Layout tab allows users to insert additional elements such as clip art, pictures, shapes, text boxes, data labels, and gridlines.

A Pie Chart represents the relative size of parts to a whole. It has specific constraints:

• Only plots a single data series.
• All data values must be positive and non-zero.
• Ideally limited to a maximum of seven categories for readability.

• 2D Charts: Plotted on two axes (X and Y). Examples include line, bar, area, column, scatter (XY), and bubble charts. Negative values are plotted on the opposite side of the origin ($O$).
• 3D Charts: Feature a third axis, the depth axis (Z-axis or series axis), allowing data to be plotted along the depth of the chart.

• Radar Chart: Compares aggregate values of multiple data series. It does not have standard horizontal category axes.
• Doughnut Chart: Similar to a pie chart but can contain multiple data series represented as concentric rings.