Graphs and Charts for Business Data: Class 12 NCERT Accountancy Guide

Understanding Graphs and Charts in Business Data

Graphs and charts are visual tools that simplify the presentation of business data. In Class 12 NCERT Accountancy, these tools help students understand and interpret data quickly.

• Graph Definition: A graph is a pictorial representation involving two dimensions—X-axis (independent variable) and Y-axis (dependent variable).
• Chart Definition: A chart is a graphical representation of data, often summarizing complex information.

Graphs can be single-line or multiple-line, where different lines represent different data series, distinguished by colours or patterns. Charts include bar charts, pie charts, and area charts, each serving unique purposes in business data analysis.

Types of Graphs and Charts Explained

Class 12 NCERT highlights several types of graphs and charts for business data:

• Bar Charts: Use vertical or horizontal bars to compare values across categories. Useful for showing absolute values.
• Single Line Graphs: Show trends over time or categories using a continuous line.
• Pie Charts: Circular charts that display parts of a whole, ideal for showing percentage shares of sub-groups.
• Area Charts: Similar to line graphs but with the area below the line filled, emphasising volume.

Each chart type helps in different business scenarios, making data easier to read and analyse.

How to Create and Format Charts Using Excel

Excel is a powerful tool for creating graphs and charts for business data. Class 12 NCERT introduces basic Excel charting features:

• Creating Charts: Use the Ribbon to insert embedded charts or chart sheets.
• Chart Tools Tabs:
• Design: Change chart styles and data.
• Layout: Adjust chart elements like titles and legends.
• Format: Modify text, colours, and shapes.

• Moving Charts: Right-click the chart and select "Move here" to reposition.
• Formatting Tips: You can edit titles, labels, and data markers but not all chart elements can be changed arbitrarily.

Example: To create a bar chart showing quarterly sales:

1. Select sales data. 2. Go to Insert > Charts > Bar Chart. 3. Use Design tab to choose style. 4. Use Layout tab to add chart title "Quarterly Sales".

This process helps students quickly visualise business data.

Best Practices for Using Pie Charts in Business Data

Pie charts are effective for showing how parts relate to a whole but have limitations:

• Category Limit: Use no more than seven categories for clarity.
• Proportional Representation: Each slice shows a percentage share.
• Avoid Overcrowding: Too many slices make the chart hard to read.

Example: If a company’s revenue sources are:

• Product A: 40%
• Product B: 25%
• Product C: 20%
• Others: 15%

A pie chart visually shows these shares clearly.

Pie charts are best when you want to highlight the distribution of a single variable’s sub-groups.

Comparing Bar Charts and Line Graphs for Business Analysis

Both bar charts and line graphs are common in business data analysis but serve different purposes:

Example:

• Use a bar chart to compare sales of different products in a quarter.
• Use a line graph to track monthly sales growth over a year.

Choosing the right graph type helps in clearer communication of business insights.