Class 12 Commerce . Accountancy . Computerised Accounting System . Graphs and Charts for Business Data

Chapter 4: Graphs And Charts For Business Data

Ch 4

Accountancy

Class 12 Commerce

Lecture 1

Introduction & Graphs And Charts

Definition

Graph — A graph is a pictorial representation of data that shows a relationship between at least two dimensions.

Why use graphs and charts?

  • Purpose: Convert accounting data into a visual form that is easier to understand and communicate than raw data.
  • Use: Graphs and charts help present business information clearly.

Types of Graphs and Charts

Key features and uses

  • Axes: A graph has at least two axes: the XX-axis is usually horizontal and the YY-axis is vertical.
  • Line graph: May be a single-line graph or a multiple-line graph.
  • Multiple-line graph: Different line styles and shades of colour can distinguish the data series and improve clarity.
  • Pie chart: Represents multiple sub-groups of a single variable.
  • Bar diagram: Depicts two or more variables.
Examples of product-wise total sales shown as a bar chart, single-line graph, pie chart and area chart.
Examples of product-wise total sales shown as a bar chart, single-line graph, pie chart and area chart.

Charts in Excel

  • Excel tools: Excel provides standard chart commands on the Ribbon for making different types of graphs and charts.
  • Basic approach: Select the worksheet data, open the Insert tab, then choose the desired chart type.
The Excel Ribbon provides tools for creating different chart types.
The Excel Ribbon provides tools for creating different chart types.

Creating a chart in Excel 2007

  1. Open the worksheet containing the data.
  2. Click the Insert tab on the Ribbon.
  3. Choose the desired chart type to display the data.
Excel chart tools with the Column chart option highlighted.
Excel chart tools with the Column chart option highlighted.

Quick recap

  • Graphs and charts present accounting data visually for clearer understanding and communication.
  • A graph shows a relationship across at least two dimensions and has at least two axes.
  • The XX-axis is usually horizontal; the YY-axis is usually vertical.
  • Line graphs can be single-line or multiple-line; styles and colours help distinguish series.
  • Pie charts show sub-groups of one variable; bar diagrams depict two or more variables.
  • In Excel 2007, use the Insert tab to select a chart type for worksheet data.
Lecture 2

Basics Steps For Graphs /Charts/ Diagrams Using Excel Part- I

Entering and Organising the Data

Definition

Chart or graph — A chart or graph is a pictorial presentation of data that makes comparisons and patterns easier to understand.

Step 1: Enter the worksheet data

  • Enter sales for each product across Qtr1–Qtr4, then include product totals and quarter totals.
  • Row totals show each product’s total sales; the Total row gives sales by quarter.
  • Grand total is the overall sales value, shown where the total row and total column meet.
ABC Manufacturing Company Ltd. — Sales for 2007–08 (Rs. in thousand)
ProductQtr1Qtr2Qtr3Qtr4Total
Toothpaste12,3442,3453,4564,56722,712
Toothbrush3,4565002,4565,41511,827
Hair Oil3,6781,3459883,3219,332
Shampoo2,9003,1903,4803,77013,340
Toilet Soap1,1222,0352,9483,8619,966
Bath Soap2,3441,8801,4169526,592
Total25,84411,29514,74421,88673,769

Creating Charts in Excel

Basic chart-creation process

  1. Select the data to be charted, including its category labels and values.
  2. Open the Insert tab and choose a chart type from the Charts group on the Ribbon.
  3. Choose a suitable chart or subtype to display the selected data.
  4. Add or format chart elements as needed.
Worked example

How can the product-wise sales totals be displayed as a bar chart?

  1. To chart product-wise total sales, select each product name and its Total value from the worksheet.
  2. Use Insert > Charts and choose a bar chart.
  3. The chart compares the six products; Toothpaste has the highest total at Rs. 22,712 thousand.
Answer: Select the product names and their total sales, then choose Insert > Charts > Bar Chart.
Bar chart comparing total sales across the six products.
Bar chart comparing total sales across the six products.

Step 2b: Chart quarter-wise total sales

  • Reorganise the worksheet data so the four quarter names and their total sales are together.
  • Select the quarter labels and values, then insert a suitable chart from the Ribbon.
  • Choose chart types and subtypes to suit the comparison; examples include a column chart, a stacked column chart, a pie chart, or a pie chart in 3-D.
  • Combine more than one chart type in a combination chart when the data and comparison require it.
Quarter-wise total sales (Rs. in thousand)
PeriodTotal Sales
Qtr125,844
Qtr211,295
Qtr314,744
Qtr421,886
Total73,769
Quarterly sales chart comparing total sales across the four quarters.
Quarterly sales chart comparing total sales across the four quarters.

Elements of a Chart or Graph

Main chart elements
ElementMeaning
Chart areaThe entire chart, including all its elements.
Plot areaThe region where data is plotted; in 2-D it is bounded by the X- and Y-axes, and in 3-D by the X-, Y- and Z-axes.
Data point / markerAn individual value shown as a bar, column, line, pie slice or another shape.
Data seriesRelated data points, usually shown in the same colour or pattern.
Category (horizontal) axisUsually the X-axis; displays categories or independent values.
Value (vertical) axisUsually the Y-axis; displays the dependent data values.
LegendIdentifies the data series or categories represented by colours or patterns.
Chart and axis titlesDescriptive text naming the chart and its axes.
Data labelExtra information attached to a data marker, identifying its value or details.

Displaying and formatting elements

  • Default display: Some chart elements appear automatically; others can be added when required.
  • Formatting: Elements and the overall chart display can be changed to suit the purpose.
Annotated quarterly sales chart identifying the key chart elements.
Annotated quarterly sales chart identifying the key chart elements.
Practice

What data should be selected to chart the total sales of each product?

Hint: Include the categories and the values being compared.
Key step: Select the six product names and their corresponding Total values.
Solution: Select each product name and its total sales value, then insert a suitable chart such as a bar chart.
Practice

Which quarter had the lowest total sales, and what data would you select to chart quarter-wise sales?

Hint: Compare the four quarterly totals.
Key step: Qtr2 has the smallest value: 11,295.
Solution: Qtr2 had the lowest sales at Rs. 11,295 thousand. Select Qtr1–Qtr4 and their totals, then insert a chart.
Practice

Which chart element identifies the colours or patterns used for different data series?

Hint: Look for the chart’s key.
Key step: The legend links colours or patterns to series or categories.
Solution: The legend identifies the data series or categories represented by different colours or patterns.

Quick recap

  • Enter the data with product totals, quarter totals and the overall total before charting.
  • Select the relevant labels and values, then use Insert > Charts on the Ribbon.
  • A bar chart can compare product-wise totals; reorganised data can show quarterly totals.
  • Excel offers chart types and subtypes, including stacked column and pie-in-3-D charts, and can combine different chart types.
  • Chart area is the whole chart; plot area is where the data is plotted.
  • Axes, data markers, series, legends, titles and data labels help explain a chart.
Lecture 3

Basics Steps For Graphs /Charts/ Diagrams Using Excel Part- Il

Formatting a Chart with the Design Tab

Excel’s Chart Tools ribbon, with the Design, Layout and Format tabs.
Excel’s Chart Tools ribbon, with the Design, Layout and Format tabs.
Grouped bar chart comparing quarterly sales of six products.
Grouped bar chart comparing quarterly sales of six products.

Selecting and Formatting a Chart Element

Spreadsheet chart-formatting ribbon with chart-area, style, arrangement and sizing tools.
Spreadsheet chart-formatting ribbon with chart-area, style, arrangement and sizing tools.
Chart Area selection and formatting controls in a spreadsheet application.
Chart Area selection and formatting controls in a spreadsheet application.

Changing Shape Style, Fill and Effects

  • Shape styles: Apply a predefined style or choose a custom fill for the selected chart element.
  • Fill and effects: Use colours, pictures, gradients or textures; effects such as bevel, reflection and shadow can enhance its appearance.

Changing Shape Outline

  • Outline colour: Choose a theme or standard colour, select a custom colour, or remove the outline with No Outline.
  • Line weight: Change the thickness of a line or border using the Weight option.
  • Line style: Use Dashes to select a broken-line pattern, or choose further styles under More Lines.
  • Arrows: Add an arrow style to a line; additional options are available under More Arrows.

Quick recap

  • Click a chart to display the Chart Tools tabs: Design, Layout and Format.
  • Use Design options to change chart type, layout and style; Switch Row/Column changes the category and series orientation.
  • Select an element directly or from the Chart Elements box, then use Format Selection to edit it.
  • Shape Fill includes colours, no fill, picture, gradient and texture options.
  • Shape Outline controls colour, visibility, line weight, dashes and arrows.
  • Shape Effects include presets, reflection and bevel, when available for the selected element.
Lecture 4

Basics Steps For Graphs /Charts/ Diagrams Using Excel Part- Ill

Formatting Chart Text

Definition

Chart text formatting — Chart text formatting changes the appearance of text in titles, labels and other chart elements.

  • Select the chart element containing the text to format.
  • Regular formatting is available from the Mini toolbar or the Font group on the Home tab.
  • WordArt formatting is available in the WordArt Styles group on the Format tab.
  • Text effects include Text Fill, Text Outline, Shadow, 3-D Format, 3-D Rotation and Text Box.
WordArt style options for formatting chart text.
WordArt style options for formatting chart text.

Select a Chart Element from the Ribbon

  1. Click anywhere in the chart to display the Chart Tools tabs.
  2. On the Format tab, open the Chart Elements list in the Current Selection group and choose an element.
  3. Choose the required formatting option from the WordArt Styles group.

Changing the Layout of Chart Elements

Definition

Chart layout — Chart layout controls the placement and appearance of chart elements such as labels, axes and backgrounds.

  • Layout tab tools can insert or adjust pictures, clip art, data labels and gridlines.
  • Format Element dialog lets you choose a category and set options for the selected chart element.
Ribbon tools for chart labels, axes, backgrounds and analysis.
Ribbon tools for chart labels, axes, backgrounds and analysis.

Changing the Chart Type

Definition

Changing chart type — A chart type can be changed to present the same data in a form better suited to its purpose.

  • Pie chart use is appropriate for showing how categories make up a whole.
  • Suitable data for the conversion described consists of one data series with positive, non-zero values.
  • Category limit in the Excel version described is seven categories; the categories represent parts of the whole.
  • Pie interpretation: each slice represents its category's share, and all slices together represent the total.
Category Share in a Pie Chart
vi∑vi×100%\frac{v_i}{\sum v_i}\times 100\%

Use this to calculate the percentage represented by a category; viv_i is its value and ∑vi\sum v_i is the total.

A 3-D pie chart showing quarterly sales shares.
A 3-D pie chart showing quarterly sales shares.
Common chart types, including column, line, pie, bar, area and scatter.
Common chart types, including column, line, pie, bar, area and scatter.

Create and Format a 3-D Pie Chart

  1. Enter category names and values in two adjacent columns, then select both columns.
  2. Choose Pie from the chart types on the ribbon, then select 3-D Pie.
  3. Use the Design tab to choose a chart layout and style.
  4. On the Format tab, use Shape Effects to apply bevels; set the top and bottom bevel sizes and choose a material if required.
  5. Use Shape Effects to choose an outer, inner or perspective shadow.
  6. To change slice orientation, select the plot area and open Format Selection; set the angle of the first slice to a value from 0 to 360 degrees.
  7. To change workbook theme colours, choose a built-in theme from the Themes group on the Page Layout tab.
⚠ Common mistake

Treat the one-series, positive, non-zero data conditions as suitability guidance for the conversion described, not as universal prohibitions for every Excel pie chart or version.

What data is suitable for the pie-chart conversion described?

Answer: One data series with positive, non-zero values; the described Excel version allows up to seven categories.

How can the first slice of a pie chart be rotated?

Answer: Select the plot area, open Format Selection and change the angle of the first slice to a value between 0 and 360 degrees.

Quick recap

  • Chart text can be formatted with standard font controls or WordArt effects.
  • Chart elements can be selected from the Chart Elements list and formatted through ribbon tabs or the Format Element dialog.
  • Pie charts show category proportions as slices of one whole.
  • Suitable conversion data in the described method has one series of positive, non-zero values; the source notes a seven-category limit for the Excel version described.
  • 3-D pie formatting can include layout and style choices, bevels, materials, shadows and rotation.
  • Themes change the workbook colours applied to the chart.
Lecture 5

Basics Steps For Graphs /Charts/ Diagrams Using Excel Part- IV

Resizing a Chart

Definition

Resizing a chart — Changing a chart’s dimensions to the size required for clear presentation.

Key points

  • Select the chart, then move the pointer to a corner or middle point on its border.
  • Resize when the pointer becomes a two-headed arrow: drag the border to the required size.
  • Formatting the chart’s title, legend and fonts can be adjusted independently.

Resize a chart

  1. Click the chart to select it.
  2. Move the pointer to a corner or border until it changes to a two-headed arrow.
  3. Drag the border to enlarge or reduce the chart.

Two-Dimensional Charts and Axes

Definition

Two-dimensional (2-D) chart — A chart that presents data using two axes: the horizontal category axis and the vertical value axis.

Axes in a 2-D chart
AxisDirectionWhat it usually represents
XX-axisHorizontalCategories or independent values, such as months
YY-axisVerticalData or derived values, such as demand

Key points

  • Axis: a line bordering the chart plot area that provides a measurement reference.
  • Origin: the point where the XX-axis and YY-axis intersect.
  • Positive and negative values: on the XX-axis, positive values are right of the origin and negative values left; on the YY-axis, positive values are above and negative values below.
  • Example: profit may be plotted as a positive value and loss as a negative value.
Coordinate axes showing positive and negative directions from the origin.
Coordinate axes showing positive and negative directions from the origin.

Common 2-D chart types

  • Types include line, bar, area, surface, column, multiple-line, radar, XY (scatter) and bubble charts.
  • Column charts may be displayed horizontally or vertically, depending on the chart layout.
Worked example

How should monthly product demand be plotted on a 2-D chart?

  1. Place the months, which are the independent categories, on the horizontal axis.
  2. Place the corresponding monthly demand values in rupees on the vertical axis.
Answer: Months go on the XX-axis; demand values go on the YY-axis.

Three-Dimensional Charts

Definition

Three-dimensional (3-D) chart — A chart that adds a depth dimension, allowing data to be plotted along a third axis.

Axes in a 3-D chart
AxisDirection or roleAlso called
XX-axisHorizontal; categoriesCategory axis
YY-axisVertical; valuesDerived-value axis
ZZ-axisDepth; data seriesSeries axis

Understanding the third dimension

  • Volume example: volume uses height, length and breadth: height is represented on the YY-axis, length on the XX-axis, and breadth on the ZZ-axis.
  • Use: the depth axis allows data series to be shown in addition to categories and values.
A cube shown along the X, Y and Z coordinate axes.
A cube shown along the XX, YY and ZZ coordinate axes.
A 3-D grouped bar chart comparing two data series across four categories.
A 3-D grouped bar chart comparing two data series across four categories.

Radar, Pie and Doughnut Charts

Definition

Data series — A set of related data points plotted together, usually identified by its own colour or pattern and shown in the chart legend.

Radar vs Pie vs Doughnut Charts
PointRadarPieDoughnut
Main useCompare aggregate values across data seriesShow parts of a wholeShow parts of a whole; can display more than one series
AxesNo horizontal category axisNo axesNo axes
SeriesCan compare multiple seriesHas only one data seriesEach ring represents a data series
Data layoutData arranged in worksheet rows or columnsData arranged in worksheet rows or columnsData arranged in worksheet rows or columns

Doughnut chart subtypes and use

  • Doughnut: displays data in rings; each ring represents one data series.
  • Exploded doughnut: separates or highlights individual values to emphasise their contribution to the total; it can show multiple series.
  • Limitation: doughnut charts can be difficult to read; a stacked column or stacked bar chart may be clearer.
Example data: lowest and highest sales
ProductLowestHighest
Toothpaste234512344
Toothbrush5005415
Hair Oil9883678
Shampoo29003770
Toilet Soap11223861
Bath Soap9522344
Total880731412
Radar chart comparing lowest and highest values for six personal-care products.
Radar chart comparing lowest and highest values for six personal-care products.
Doughnut chart comparing sales across six product categories and highlighting the lowest sales.
Doughnut chart comparing sales across six product categories and highlighting the lowest sales.

Advantages of Graphs and Charts

Three main advantages
PurposeHow charts help
ExploreReveal possible relationships between variables quickly, without examining large amounts of raw data.
PresentSummarise and communicate information quickly and clearly.
ConvinceTurn large amounts of information into visual evidence that can support persuasion.
Practice

Which chart is suitable for comparing the lowest and highest sales values of several products?

Hint: Choose a chart designed to compare multiple data series across categories.
Key step: The two series are lowest sales and highest sales; the products are categories.
Solution: A radar chart is suitable for comparing the two series across the products.
Practice

A chart must show parts of a whole for more than one data series. What chart can be used, and what clearer alternative may be considered?

Hint: Think of a chart with separate rings for separate series.
Key step: Each doughnut ring represents one data series, but doughnut charts can be hard to read.
Solution: Use a doughnut chart; consider a stacked column or stacked bar chart if clearer comparison is needed.

Quick recap

  • Resize a selected chart by dragging a corner or border; chart text and other elements can be formatted independently.
  • A 2-D chart uses the XX-axis for categories and the YY-axis for values; the axes meet at the origin.
  • Positive and negative values appear on opposite sides of the origin on both axes.
  • A 3-D chart adds the depth or series axis, the ZZ-axis; height maps to YY, length to XX, and breadth to ZZ.
  • Radar charts compare data series; pie charts show one series as parts of a whole; doughnut charts can show multiple series as rings.
  • Charts help users explore data, present information quickly and support persuasion.
Lecture 6

Summary

Graphs and Chart Types

Definition

Graph — A graph is a pictorial representation of data, usually shown in two dimensions; three-dimensional graphs are also sometimes used.

Single-Line Graph vs Multi-Line Graph
PointSingle-line graphMulti-line graph
Lines shownOne data seriesTwo or more data series
Distinguishing seriesNot neededUse different line shapes or different line shapes and colours
Common Pictorial Representations
Chart typeWhat it showsTypical use
Pie chartRelative share of different elementsShowing how a whole is divided among categories
Bar chartComparison of absolute data valuesComparing sales or production across products or time intervals

Why Use Graphs and Charts?

  • Visualisation: Graphs and charts make patterns and trends in data easier to see.
  • Random data: They can make fluctuating data, such as stock prices, easier to understand than a textual description.

Chart Components in Excel

Main Chart Elements
ElementPurpose
Chart areaThe overall area containing the chart and its elements
Plot areaThe area where the selected chart type displays the data
Data pointsThe individual values represented in the chart
Horizontal axisUsually shows base values, such as categories
Vertical axisUsually shows derived values
LegendExplains how lines, pie sections, bars or other series are distinguished
Chart and axis titlesDescribe the chart and its axes
Data labelsDisplay values or other information beside data points

Formatting and Display

  • Formatting: Excel’s Design, Layout and Format options can modify chart elements, including the plot area, axes, data, titles, labels, legends and gridlines.
  • Size: Resize a chart to suit the presentation.
  • Chart type: Change the type, such as line to bar or bar to pie, when another view presents the data more effectively.
  • Visibility: Axes, gridlines, legends, titles and data labels can be shown or hidden as needed.

Preparing a Chart

Create and Finish a Chart in Excel

  1. Enter the data in a worksheet with clear row and column titles.
  2. Select the data and create a basic chart using an option in the worksheet’s Chart group.
  3. Choose a predefined chart layout or style, and adjust the layout and formatting of chart elements.
  4. Add or remove the chart title, axis titles and data labels; a chart title can be linked to a worksheet cell.
  5. Show or hide the legend.
  6. Show or hide primary or secondary axes and gridlines.
  7. Move or resize the chart to fit the worksheet or presentation.
  8. Save the completed chart.
Worked example

How can a chart be used to compare sales of several products in Excel?

  1. A worksheet lists sales for several products. Give a suitable chart and outline how to prepare it.
  2. Enter product names and sales values under clear column headings, then select the data.
  3. Choose a bar chart because the task is to compare absolute sales values across discrete product categories.
  4. Add a meaningful chart title and, if useful, axis titles or data labels; format the chart and show a legend if needed.
  5. Resize or move the chart as required and save it.
Answer: Use a bar chart to compare absolute sales by product, then label, format, position and save it.
Practice

Which chart is generally suitable for showing the relative shares of different expense categories?

Hint: Choose the chart type that shows parts of a whole.
Key step: A pie chart displays relative shares.
Solution: A pie chart.
Practice

How can multiple data series be distinguished in a multi-line graph?

Hint: Consider line appearance and the legend.
Key step: Use different line shapes or combinations of line shapes and colours; use the legend to identify them.
Solution: Distinguish the lines by their shapes or by shapes and colours, and use the legend to explain the criteria.

Quick recap

  • Graphs pictorially represent data; they are usually two-dimensional.
  • Pie charts show relative shares, while bar charts compare absolute values across categories or time intervals.
  • Multi-line graphs distinguish series through line shapes and/or colours, with a legend explaining them.
  • Excel charts include a chart area, plot area, data points, axes, legend, titles and data labels.
  • Excel lets users format, resize and change chart types to improve presentation.
  • Prepare charts by entering labelled data, selecting a chart, adjusting its elements and appearance, then saving it.

Formula sheet

Category Share in a Pie Chart
vi∑vi×100%\frac{v_i}{\sum v_i}\times 100\%

Accountancy — ALL CHAPTERS

1

Accounting for Share Capital

View

2

Issue and Redemption of Debentures

View

3

Financial Statements of a Company

View

4

Analysis of Financial Statements

View

5

Accounting Ratios

View

6

Cash Flow Statement

View

1

Overview Of Computerised Accounting System

View

2

Spreadsheet

View

3

Use Of Spreadsheet In Business Applications

View

4

Graphs And Charts For Business Data

View

1

Accounting for Partnership: Basic Concepts

View

2

Reconstitution of a Partnership Firm –Admission of a Partner

View

3

Reconstitution of a Partnership Firm –Retirement/Death of a Partner

View

4

Dissolution of Partnership Firm

View