NIOS Senior Secondary • Module 7

Lesson 37: Graphs and Charts

Computerised Accounting Focus

Lesson 37: Graphs and Charts in Financial Accounting

Extracted strictly from NIOS Senior Secondary Accountancy Module 7. Covers chart types, anatomy elements, creation workflows, formatting option ribbons (Design, Layout, Format), and decision-making advantages.

1 Meaning, Types & Business Advantages of Graphs and Charts

Section 37.1 & 37.5

Core Concept & Definition

Graphs and Charts are pictorial representations of data that exhibit at least a two-dimensional relationship (X-axis and Y-axis). They transform complex numerical accounting data into intuitive graphic formats, embodying the principle that "A picture is worth more than a thousand words."

Dimensional Axes Relationship
  • 2-D Charts: Operate on 2 axes — X-Axis (Horizontal Category Axis, independent variables) and Y-Axis (Vertical Value Axis, dependent numerical data).
  • 3-D Charts: Feature 3 axes — X-Axis, Y-Axis, and Z-Axis (Depth axis representing data series depth).
Excel Chart Types Portfolio

Excel provides multiple chart styles via the Insert Tab:

  • Column Chart: Illustrates comparisons and data changes over time.
  • Line Chart: Tracks continuous trends over time intervals.
  • Pie Chart: Shows relative proportions of a single series (Max 7 categories).
  • Bar, Area, Scatter (X-Y), Doughnut, 3-D Charts: Specialized analytical views.

3 Core Decision-Making Advantages

1. Help to Explore

Quickly reveals hidden relationships between accounting variables (e.g., GNP vs. mortality, age vs. gender) without scanning raw tabular rows.

2. Help to Present

Conveys complex financial statistics instantly, allowing stakeholders and financial press to grasp high-level summary trends rapidly.

3. Help to Convince

Transforms massive data tables into compelling visual exhibits that effectively persuade management and investors during business pitches.

2 The 7 Fundamental Anatomy Elements of a Chart

Section 37.2

To interpret and format any Excel chart correctly, accountants must master its 7 structural elements:

1. Chart Area

The entire chart frame including all graphics, titles, legends, and plot bounds.

2. Plot Area

The specific bounded area containing the plotted data points (bounded by X/Y axes in 2-D or X/Y/Z in 3-D).

3. Data Points & Data Series

Individual values plotted as bars, lines, or slices are Data Markers. Related markers sharing a color/pattern form a Data Series.

4. Category (X) & Value (Y) Axes

X-Axis (Horizontal Category): Contains independent values/categories. Y-Axis (Vertical Value): Contains dependent numerical data.

5. Legend

The color-coded key box that identifies each data series or category plotted in the chart.

6. Chart & Axes Titles

Descriptive heading text giving clarity to the chart title and horizontal/vertical axes names.

7. Data Labels

Additional numerical or text callouts displayed directly on or beside individual data markers to specify exact data values.

3 Excel Chart Tools Contextual Ribbon Tabs

Section 37.1.3 & 37.3-37.4

When you click on a chart in Excel, three special contextual tabs appear under Chart Tools on the Ribbon:

Design Tab
  • Chart Type: Change to Column, Line, Pie, etc.
  • Chart Layouts & Styles: Preset color and visual styles.
  • Data Group: Switch Row/Column button to swap orientation; Select Data to edit ranges.
  • Location: Move chart to new sheet or embedded sheet.
Layout Tab
  • Insert: Pictures, Shapes, and Text Boxes.
  • Labels: Chart Title, Axis Titles, Legend, Data Labels, Data Table.
  • Axes & Gridlines: Toggle primary/secondary axes and major/minor gridlines.
  • Analysis: Trendlines and error bars.
Format Tab
  • Current Selection: Dropdown to target specific chart elements.
  • Shape Styles: Shape Fill (Color, Picture, Gradient, Texture), Outline, Effects (Shadow, Bevel, 3D Rotation).
  • WordArt Styles: Text Fill, Text Outline, Text Effects.

Mandatory Rules for Pie Charts (Section 37.4.5)

  • Single Series Only: Plots exactly ONE data series representing parts of a whole pie.
  • Positive Non-Zero Values: All plotted data values must be positive and non-zero.
  • Maximum 7 Categories: Excel cannot plot more than 7 categories effectively in a pie chart due to slice legibility constraints.
  • Slice Rotation: Slices can be rotated from 0° to 360° via Angle of First Slice under Format Selection.