Chapter 4 Graphs and Charts ENGLISH WITH MALAYALAM NOTE

Chapter 4: Graphs and Charts for Business Data

📌 Chapter 4 – Important Topics:

Introduction – Importance of visual data representation
Types of Charts – Column, Bar, Line, Pie, Area, Scatter (XY), Bubble, Radar, Stock, Column & Line, Exploded Pie, Donut, Exploded Donut
Steps to Create a Chart in LibreOffice Calc
Elements of a Chart – Chart Area, Plot Area, Axis, Data Labels, Gridlines, Legend
Formatting Charts – Titles, Legend, Data Labels, Gridlines, Resizing, Moving
2D vs 3D Charts
Advantages of Charts and Graphs
Previous Year Exam Questions (2018–2024)

Introduction

Charts and graphs are used to make information clear and easier to understand. A good picture is worth a thousand numbers. Spreadsheet offers many types of charts including: Column, Line, Pie, Bar, Area, Scatter and more.

Simple Explanation: Charts turn rows of numbers into pictures. You can instantly see which product sells the most, how sales are changing over time, or how your budget is divided.

Complementary Explanation: In business, managers rarely have time to read raw data tables. A well‑designed chart communicates the key message in seconds – it is the language of decision‑making.

📌 Live Example 1 – Sales Comparison: A company sells laptops (12,000 units), desktops (10,000), tablets (14,000) and mobiles (4,000). A column chart immediately shows that tablets are the best‑selling product.

📌 Live Example 2 – Trend Analysis: A retailer records monthly sales for five years. A line chart reveals seasonal peaks and long‑term growth – something impossible to spot in a spreadsheet of 60 numbers.

💭 Think: Why do newspapers and websites always use charts instead of tables to report election results or stock market changes?
Simple Hints: Faster understanding, no need to read numbers, visual impact.

Types of Charts in Spreadsheet

LibreOffice Calc provides variety of charts to express your data more meaningfully. Following are the most widely used charts in LibreOffice Calc.

1. Column Chart

In the column chart, categories are displayed horizontally and values vertically. Column chart works well when we want to compare data sets between each other.

Simple Explanation: Column charts use vertical bars. The higher the bar, the larger the value. Use them to compare different items (e.g., sales of four products).

Complementary Explanation: In Calc, you can create a column chart in seconds: select your data, click Insert → Chart, choose Column. The wizard does the rest.

📌 Live Example 1 – Branch Performance: A bank has five branches. Monthly deposits: ₹45L, ₹32L, ₹28L, ₹41L, ₹37L. A column chart shows at a glance which branch is the top performer.

📌 Live Example 2 – Exam Results: Class XII Commerce scores in five subjects. A column chart compares subject‑wise average marks – helpful for teachers and students.

💭 Think: If you have 20 years of sales data, is a column chart still a good choice? Why/why not?
Simple Hints: Too many columns clutter the chart. A line chart is better for long time series.

2. Line Chart

The line chart shows data changes for a certain period of time. In other words, the line chart is good for determining trends.

Simple Explanation: Line charts connect data points with lines. They are perfect for showing trends over time – monthly profit, annual revenue, temperature changes.

Complementary Explanation: Unlike column charts, line charts emphasise the direction of change (up, down, flat) rather than exact comparison.

📌 Live Example 1 – Share Price: A stock’s closing price for 30 days plotted as a line chart. You can instantly see bull/bear trends and volatility.

📌 Live Example 2 – Website Visitors: Daily visitors over one year. The line chart shows weekly patterns, holiday dips, and overall growth.

💭 Think: Can you use a line chart to compare two products’ sales over five years? How?
Simple Hints: Yes – plot two lines in the same chart, use different colours, and add a legend.

3. Pie Chart

The pie chart contains only one data series. A series of data in a pie chart is displayed as a percentage of the total.

Simple Explanation: A pie is a circle cut into slices. The whole circle = 100%. Each slice = a category’s share. Use it to show “parts of a whole”.

Complementary Explanation: Pie charts are most effective when you have fewer than six categories and the slices are visibly different.

📌 Live Example 1 – Family Budget: Food 40%, Rent 25%, Transport 15%, Savings 20%. A pie chart clearly shows where the money goes.

📌 Live Example 2 – Market Share: Four mobile brands hold 45%, 30%, 15%, 10% market share. A pie chart instantly communicates who the leader is.

💭 Think: Why is it difficult to compare two similar‑sized slices (e.g., 22% and 24%) in a pie chart?
Simple Hints: The human eye cannot easily judge small angle differences. A bar chart would be better.

4. Bar Chart

The bar chart is similar to the column chart, with the difference being that the data series are displayed horizontally and not vertically. Similar to the column chart, in the bar chart we can compare one or more data series.

Simple Explanation: Bar charts are column charts turned sideways – horizontal bars. They are useful when category names are long.

Complementary Explanation: Use a bar chart when you have many categories; the horizontal space makes labels easy to read.

📌 Live Example 1 – Employee Satisfaction: Survey results for 10 departments. Long department names fit perfectly on the vertical axis (Y‑axis) of a bar chart.

📌 Live Example 2 – Project Duration: Comparing completion times of 8 projects. Horizontal bars make it easy to rank them from longest to shortest.

💭 Think: Your chart has 15 product names, each with 15+ characters. Which chart type is better: column or bar?
Simple Hints: Bar chart – names are displayed vertically without tilting or truncating.

5. Area Chart

Area charts emphasize the size of changes in time and allow you to focus on the sum of the whole trend. By using the area chart, you can display data that represents the gain in time, in order to emphasize the amount of profits.

Simple Explanation: An area chart is like a line chart, but the space below the line is filled with colour. It highlights the volume or magnitude of change.

Complementary Explanation: Stacked area charts can show how different components contribute to the total over time.

📌 Live Example 1 – Quarterly Profit: Plot quarterly profit as an area chart – the filled area visually emphasises the profit accumulated each quarter.

📌 Live Example 2 – Website Traffic Sources: Stacked area chart showing traffic from organic search, social media, and direct visits over 12 months. You see both the total and each source’s contribution.

💭 Think: If you overlay two area charts with different colours, what problem might arise?
Simple Hints: The front area may hide the back area. Use transparency or use a line chart instead.

6. Scatter Chart (XY Chart)

This type of chart is often used to show the relationship between two variables. The Scatter charts are commonly used for scientific and financial data.

Simple Explanation: Scatter plots use dots to show the relationship between two sets of numbers (e.g., advertising spend vs sales). Each dot = one pair of values.

Complementary Explanation: If the dots form a pattern (upward slope), the variables are positively correlated. No pattern = no correlation.

📌 Live Example 1 – Marketing Analysis: 10 regions: advertising budget (X) and sales (Y). A scatter chart reveals whether more ads lead to more sales.

📌 Live Example 2 – Scientific Experiment: Temperature (X) and pressure (Y) readings from a physics lab. Scatter chart helps to identify the relationship.

💭 Think: Can a scatter chart show how a variable changes over time?
Simple Hints: Yes – if you put time on the X‑axis. But a line chart is usually better for time series.

7. Bubble Chart

This chart shows the data in the form of bubbles, which will help to identify the data size easily.

Simple Explanation: Bubble charts are like scatter charts, but the size of the dot (bubble) represents a third variable.

Complementary Explanation: It is a 3‑dimensional visualisation (X, Y, bubble size) on a 2D plane.

📌 Live Example 1 – Product Analysis: X = price, Y = sales, bubble size = profit margin. Instantly see which products are profitable despite low sales.

📌 Live Example 2 – Country Comparison: X = GDP per capita, Y = life expectancy, bubble size = population. Compare countries on three dimensions.

💭 Think: What happens if many bubbles overlap?
Simple Hints: The chart becomes messy. Use transparency or filter the data.

8. Radar Chart / Net Chart

This chart shows the data in the form of a cobweb (spider net).

Simple Explanation: A radar chart has multiple axes (like spokes of a wheel) radiating from the centre. Each axis represents a category. The data points are connected, forming a polygon.

Complementary Explanation: It is ideal for comparing the performance of several items across the same set of criteria.

📌 Live Example 1 – Employee Skill Assessment: Evaluate three employees on communication, technical skill, teamwork, punctuality. Radar chart shows strengths/weaknesses at a glance.

📌 Live Example 2 – Product Features: Compare two mobile phones on battery, camera, storage, price, display – all on a single radar chart.

💭 Think: If you have 15 criteria, is a radar chart still readable?
Simple Hints: No – too many axes create a dense web. Use a bar chart instead.

9. Stock Chart

This chart is used to demonstrate the fluctuations in security market with respect to stock market price.

Simple Explanation: Stock charts display high, low, open, and close prices – often as candlesticks or OHLC bars.

Complementary Explanation: They are specialised for financial data and are not commonly used in general business reporting.

📌 Live Example 1 – Daily Stock Prices: Show Infosys share price: open, high, low, close for 30 days. Traders use this to identify trends.

📌 Live Example 2 – Commodity Prices: Gold prices with daily range. Stock chart highlights volatility.

💭 Think: Why do stock charts require four data series (open, high, low, close)?
Simple Hints: To give a complete picture of price movement within a period.

10. Column and Line Chart

It shows different sets of data in the form of column and line at a time (Minimum 2 sets of data required).

Simple Explanation: A combination chart – columns for one data series, a line for another – often used to compare actual vs target.

Complementary Explanation: The secondary axis can be used if the scales are different.

📌 Live Example 1 – Sales vs Target: Monthly actual sales as columns, target sales as a line. Instantly see which months missed the target.

📌 Live Example 2 – Revenue vs Growth Rate: Revenue as columns, year‑on‑year growth percentage as a line on the secondary axis.

💭 Think: What could go wrong if both series have very different units (₹ vs %)?
Simple Hints: Use a secondary vertical axis to give each series its own scale.

11. Exploded Pie Chart

Exploded pie chart is the kind of pie chart in which one or several slices are separated from the other. It is useful because it makes the highlighted portion more visible.

Simple Explanation: A pie chart with one slice “pulled out” – emphasises that slice.

Complementary Explanation: Use it sparingly – only when one category is especially important.

📌 Live Example 1 – Budget Allocation: Government budget – pull out the “Defence” slice to highlight its share.

📌 Live Example 2 – Market Share: Show that “Brand A” has 55% – explode its slice to draw attention.

💭 Think: If you explode all slices, what do you get?
Simple Hints: An exploded donut chart (if the centre is hollow) or just a messy pie.

12. Donut Chart

A Donut or Doughnut chart is a pie chart, with two exceptions: It has a hole in the middle and it can display more than one series of data. Doughnut charts display data in rings, where each ring represents a data series. The first data series is displayed in the centre of the chart.

Simple Explanation: Like a pie chart with a hole. It can show multiple data series as concentric rings.

Complementary Explanation: The hole can be used to display a total or a label.

📌 Live Example 1 – Two‑Year Sales Breakdown: Inner ring = 2023 sales by product, outer ring = 2024 sales by product. Compare composition year over year.

📌 Live Example 2 – Department Budgets: Show each department’s budget as a segment of the donut; the hole shows the total budget.

💭 Think: Why is a donut chart often criticised as harder to read than a pie?
Simple Hints: The hole reduces the area for slices, making angle differences even harder to judge.

13. Exploded Donut Chart

It is a Donut chart with all slices exploded. It shows the outer sectors already separated from the remaining Donut.

Simple Explanation: A donut chart with every slice pulled apart – not commonly used because it’s visually busy.

Complementary Explanation: Use only when you must emphasise every category.

📌 Live Example 1 – Product Portfolio: Show all five product lines exploded from the donut to stress they are distinct.

📌 Live Example 2 – Competition Ranking: Display market share of four competitors as exploded donut slices.

💭 Think: What happens to the “hole” when all slices are exploded?
Simple Hints: The hole remains in the centre, but the slices are detached from it.

Steps to Create Charts in LibreOffice Calc

Open LibreOffice Calc application.
Enter the data with column headers and row headers.
Select the data including column headers and row headers.
Select Insert → Chart → Chart Type → Next (from the ribbon).
In the Data Range step, tick the options "First row as label" and "First column as label".
Click on Finish.

Simple Explanation: Just select your numbers (including headings), click Insert → Chart, choose a style, and click Finish. Calc does the rest.

Complementary Explanation: You can also right‑click the chart later to change the chart type, data range, or formatting.

📌 Live Example 1 – Quick Column Chart: Enter product names in column A, sales figures in column B. Select A1:B5, Insert → Chart → Column → Finish. A professional chart in 10 seconds.

📌 Live Example 2 – Changing Chart Type: After creating a column chart, right‑click on it, choose "Chart Type", and switch to a pie chart to see the same data differently.

💭 Think: What happens if you forget to tick "First row as label"?
Simple Hints: Calc treats the headings as data, and you’ll get numbers on the X‑axis instead of labels.

Exam Practice (2 marks): Can you help Mr. Ajith Kumar by pointing out the missing steps to create a chart from: "Enter the data in cells → Select the data → Finish"?
Answer: The missing step is: Click on 'Insert' menu and choose 'Chart' (or use the Chart Wizard).
Hint: After selecting data, you must explicitly insert a chart – it doesn’t appear automatically.

Elements of a Chart

Chart Text – A label or title added to the chart. Eg. Chart Title, Vertical Axis Title, Horizontal Axis Title etc.
Chart Area – Entire area of the chart, which includes labels, data, axis etc.
Plot Area – It is the area in which the actual data is plotted.
Axis – A line that serves as a major reference for plotting data. X‑axis, Y‑axis and Z‑axis.
Data Labels – The values of the data series plotted are known as Data Labels. This provides additional information about data point.
Grid lines – Optional lines extending from tick marks across the plot area.
Legend – They are the indicators of data items. It is shown in the form of colours or symbols.

Simple Explanation: Every chart has building blocks: title (what it is about), axes (scales), plot area (the graph itself), data labels (the exact numbers), gridlines (guides), and legend (colour key).

Complementary Explanation: You can turn each element on/off and format its colour, font, position – all from the Format menu or by double‑clicking.

📌 Live Example 1 – Adding a Title: Double‑click the chart, go to Insert → Title, type "Annual Sales 2024". The chart instantly becomes more informative.

📌 Live Example 2 – Hiding Gridlines: To make the chart cleaner, right‑click on gridlines → Delete. Useful for presentations.

💭 Think: Why is a legend necessary when you have data labels?
Simple Hints: Data labels show values; legend tells which colour/pattern represents which data series.

Exam Practice (2 marks): Name any four elements of a spreadsheet graph or chart.
Answer: Chart Title, Axis (X & Y), Data Series, Legend, Plot Area, Gridlines (any four).
Hint: Refer to the labelled diagram in the textbook.

Formatting of Chart

A created chart can be formatted with the help of ‘Format’ Menu. To make changes in the chart – Double click the chart – Make changes by using Insert tab and Format tab. Titles, Legend, Data labels, Grid lines etc. are available on Insert tab. Title, Legend etc. can be formatted by using format tab.

Resizing the Chart

To resize the chart – Click on the chart – Drag the handles on the border.

Moving the Chart

To move the chart from one location to another – Drag the chart by mouse. Copy, Cut and Paste functions can also be used for the same.

Simple Explanation: Charts are objects that you can move, resize, and restyle like a picture. Double‑click to enter edit mode.

Complementary Explanation: Use the “Format” menu or right‑click context menu to change colours, fonts, borders, and 3D settings.

📌 Live Example 1 – Resize for Report: Click the chart, drag a corner handle outward – chart enlarges while keeping proportions. Perfect for filling a page.

📌 Live Example 2 – Move to New Sheet: Right‑click chart border → Cut, then paste it on a separate worksheet. Keeps data and chart together.

💭 Think: What is the difference between moving a chart and changing the data range?
Simple Hints: Moving changes location on the sheet; changing data range plots different data.

2D – 3D Charts

The term 2D and 3D are used to indicate dimensions. 2D stands for Two‑Dimensional, whereas 3D stands for Three‑Dimensional. 2D represents an object in just two dimensions in X and Y axes, while 3D represents it in three dimensions in X, Y and Z axes.

Simple Explanation: 2D charts are flat (like a drawing on paper). 3D charts add depth – they look more realistic but can sometimes distort perception.

Complementary Explanation: Use 3D sparingly – for presentations where visual impact matters, but avoid it for precise data analysis.

📌 Live Example 1 – 3D Column Chart: Sales data of 4 regions shown as 3D columns. Looks impressive in a board meeting.

📌 Live Example 2 – 2D vs 3D Pie: A 2D pie is clear; a 3D pie with one slice exploded might tilt and hide a small slice. Choose 2D for accuracy.

💭 Think: Why do statisticians often warn against 3D charts?
Simple Hints: Perspective can make bars look taller or slices appear larger than they really are.

Advantages of using Graphs and Charts

Visually appealing
Easy to read the data
Quick analysis and interpretation of data with a little time
To know the trends easily
To grasp the data quickly
A large volume of information can be exhibited through charts easily

Simple Explanation: Charts turn complex numbers into simple pictures – faster to understand, easier to remember, and more persuasive.

Complementary Explanation: In business, a chart often replaces a thousand words. It reveals patterns, outliers, and relationships that tables hide.

📌 Live Example 1 – Investor Pitch: A startup shows revenue growth on a steep line chart – investors grasp the potential in 2 seconds.

📌 Live Example 2 – Quality Control: A scatter chart of defect rates vs production batch highlights the problem batches immediately.

💭 Think: Can a chart ever mislead? How?
Simple Hints: Yes – by truncating the Y‑axis, using 3D perspective, or choosing inappropriate chart types.

Exam Practice (2 marks): Write any two advantages of charts and graphs.
Answer: 1. Make data easy to understand and visually appealing. 2. Allow quick analysis and comparison of data points.
Hint: Think about why managers prefer charts over tables.

മലയാളം വിഭാഗം – ഗ്രാഫുകളും ചാർട്ടുകളും (ബിസിനസ്സ് ഡാറ്റയ്ക്കായി)

📌 പ്രധാന പാഠഭാഗങ്ങൾ:

ആമുഖം – ദൃശ്യ ഡാറ്റാ പ്രാതിനിധ്യത്തിന്റെ പ്രാധാന്യം
ചാർട്ടുകളുടെ തരങ്ങൾ – കോളം, ബാർ, ലൈൻ, പൈ, ഏരിയ, സ്കാറ്റർ (XY), ബബിൾ, റഡാർ, സ്റ്റോക്ക്, കോളം & ലൈൻ, എക്സ്പ്ലോഡഡ് പൈ, ഡോണട്ട്, എക്സ്പ്ലോഡഡ് ഡോണട്ട്
ലിബ്രെ ഓഫീസ് കാൽക്കിൽ ചാർട്ട് സൃഷ്ടിക്കുന്നതിനുള്ള ഘട്ടങ്ങൾ
ചാർട്ടിന്റെ ഘടകങ്ങൾ – ചാർട്ട് ഏരിയ, പ്ലോട്ട് ഏരിയ, അക്ഷങ്ങൾ, ഡാറ്റ ലേബലുകൾ, ഗ്രിഡ് ലൈനുകൾ, ലെജന്റ്
ചാർട്ടുകളുടെ ഫോർമാറ്റിംഗ് – ശീർഷകങ്ങൾ, ലെജന്റ്, ഡാറ്റ ലേബലുകൾ, ഗ്രിഡ് ലൈനുകൾ, വലുപ്പം മാറ്റൽ, നീക്കൽ
2D vs 3D ചാർട്ടുകൾ
ചാർട്ടുകളുടെയും ഗ്രാഫുകളുടെയും പ്രയോജനങ്ങൾ
മുൻവർഷ പരീക്ഷാ ചോദ്യങ്ങൾ (2018–2024)

ആമുഖം

വിവരങ്ങൾ വ്യക്തവും എളുപ്പത്തിൽ മനസ്സിലാക്കുന്നതിനും ചാർട്ടുകളും ഗ്രാഫുകളും ഉപയോഗിക്കുന്നു. ഒരു നല്ല ചിത്രം ആയിരം അക്കങ്ങളുടെ മൂല്യമുള്ളതാണ്. നിര, ലൈൻ, പൈ, ബാർ, ഏരിയ, സ്കാറ്റർ എന്നിവയും അതിലേറെയും ഉൾപ്പെടെ നിരവധി തരം ചാർട്ടുകൾ സ്പ്രെഡ്ഷീറ്റ് വാഗ്ദാനം ചെയ്യുന്നു.

ലളിതമായ വിശദീകരണം: ചാർട്ടുകൾ നിര നിരയായുള്ള അക്കങ്ങളെ ചിത്രങ്ങളാക്കി മാറ്റുന്നു. ഏത് ഉൽപ്പന്നമാണ് ഏറ്റവും കൂടുതൽ വിൽക്കുന്നത്, കാലക്രമേണ വിൽപ്പന എങ്ങനെ മാറുന്നു, അല്ലെങ്കിൽ നിങ്ങളുടെ ബജറ്റ് എങ്ങനെ വിഭജിക്കപ്പെട്ടിരിക്കുന്നു എന്നിവ നിങ്ങൾക്ക് തൽക്ഷണം കാണാൻ കഴിയും.

പൂരക വിശദീകരണം: ബിസിനസ്സിൽ, മാനേജർമാർക്ക് അസംസ്കൃത ഡാറ്റ പട്ടികകൾ വായിക്കാൻ സമയമില്ല. നന്നായി രൂപകൽപ്പന ചെയ്ത ഒരു ചാർട്ട് സെക്കന്റുകൾക്കുള്ളിൽ പ്രധാന സന്ദേശം ആശയവിനിമയം ചെയ്യുന്നു – ഇത് തീരുമാനമെടുക്കലിന്റെ ഭാഷയാണ്.

📌 ലൈവ് ഉദാഹരണം 1 – വിൽപ്പന താരതമ്യം: ഒരു കമ്പനി ലാപ്ടോപ്പുകൾ (12,000), ഡെസ്ക്ടോപ്പുകൾ (10,000), ടാബ്ലെറ്റുകൾ (14,000), മൊബൈലുകൾ (4,000) എന്നിവ വിൽക്കുന്നു. ഏറ്റവും കൂടുതൽ വിറ്റഴിക്കപ്പെടുന്ന ഉൽപ്പന്നം ടാബ്ലെറ്റുകളാണെന്ന് ഒരു കോളം ചാർട്ട് ഒറ്റനോട്ടത്തിൽ കാണിക്കുന്നു.

📌 ലൈവ് ഉദാഹരണം 2 – ട്രെൻഡ് വിശകലനം: ഒരു ചില്ലറ വ്യാപാരി അഞ്ച് വർഷത്തെ പ്രതിമാസ വിൽപ്പന രേഖപ്പെടുത്തുന്നു. 60 അക്കങ്ങളുടെ ഒരു സ്പ്രെഡ്ഷീറ്റിൽ കാണാൻ കഴിയാത്ത സീസണൽ ഉയർച്ചകളും ദീർഘകാല വളർച്ചയും ഒരു ലൈൻ ചാർട്ട് വെളിപ്പെടുത്തുന്നു.

💭 ചിന്തിക്കുക: തിരഞ്ഞെടുപ്പ് ഫലങ്ങളോ സ്റ്റോക്ക് മാർക്കറ്റ് മാറ്റങ്ങളോ റിപ്പോർട്ട് ചെയ്യുന്നതിന് പട്ടികകൾക്ക് പകരം ചാർട്ടുകൾ എന്തുകൊണ്ടാണ് പത്രങ്ങളും വെബ്സൈറ്റുകളും എല്ലായ്പ്പോഴും ഉപയോഗിക്കുന്നത്?
സൂചനകൾ: വേഗത്തിലുള്ള ഗ്രാഹ്യം, അക്കങ്ങൾ വായിക്കേണ്ട ആവശ്യമില്ല, ദൃശ്യ ആഘാതം.

സ്പ്രെഡ്ഷീറ്റിലെ ചാർട്ടുകളുടെ തരങ്ങൾ

നിങ്ങളുടെ ഡാറ്റയെ കൂടുതൽ അർത്ഥവത്തായി പ്രകടിപ്പിക്കുന്നതിന് ലിബ്രെ ഓഫീസ് കാൽക്ക് വിവിധ ചാർട്ടുകൾ നൽകുന്നു. ലിബ്രെ ഓഫീസ് കാൽക്കിലെ ഏറ്റവും വ്യാപകമായി ഉപയോഗിക്കുന്ന ചാർട്ടുകൾ ഇനിപ്പറയുന്നവയാണ്.

1. കോളം ചാർട്ട് (Column Chart)

നിര ചാർട്ടിൽ, വിഭാഗങ്ങൾ തിരശ്ചീനമായും മൂല്യങ്ങൾ ലംബമായും പ്രദർശിപ്പിക്കും. ഡാറ്റ സെറ്റുകൾ പരസ്പരം താരതമ്യം ചെയ്യാൻ ഞങ്ങൾ ആഗ്രഹിക്കുമ്പോൾ നിര ചാർട്ട് നന്നായി പ്രവർത്തിക്കുന്നു.

ലളിതമായ വിശദീകരണം: കോളം ചാർട്ടുകൾ ലംബമായ ബാറുകൾ ഉപയോഗിക്കുന്നു. ബാർ കൂടുന്തോറും മൂല്യം വലുതാണ്. വ്യത്യസ്ത ഇനങ്ങളെ താരതമ്യം ചെയ്യാൻ ഇവ ഉപയോഗിക്കുക.

പൂരക വിശദീകരണം: കാൽക്കിൽ, നിങ്ങൾക്ക് സെക്കന്റുകൾക്കുള്ളിൽ ഒരു കോളം ചാർട്ട് സൃഷ്ടിക്കാൻ കഴിയും: നിങ്ങളുടെ ഡാറ്റ തിരഞ്ഞെടുക്കുക, Insert → Chart ക്ലിക്കുചെയ്യുക, Column തിരഞ്ഞെടുക്കുക. വിസാർഡ് ബാക്കി ചെയ്യുന്നു.

📌 ലൈവ് ഉദാഹരണം 1 – ശാഖാ പ്രകടനം: ഒരു ബാങ്കിന് അഞ്ച് ശാഖകളുണ്ട്. പ്രതിമാസ നിക്ഷേപം: ₹45L, ₹32L, ₹28L, ₹41L, ₹37L. ഏത് ശാഖയാണ് മികച്ച പ്രകടനം കാഴ്ചവയ്ക്കുന്നതെന്ന് ഒരു കോളം ചാർട്ട് ഒറ്റനോട്ടത്തിൽ കാണിക്കുന്നു.

📌 ലൈവ് ഉദാഹരണം 2 – പരീക്ഷാ ഫലങ്ങൾ: ക്ലാസ് XII കൊമേഴ്സ് വിദ്യാർത്ഥികളുടെ അഞ്ച് വിഷയങ്ങളിലെ സ്കോറുകൾ. വിഷയം തിരിച്ചുള്ള ശരാശരി മാർക്ക് താരതമ്യം ചെയ്യുന്ന കോളം ചാർട്ട് – അധ്യാപകർക്കും വിദ്യാർത്ഥികൾക്കും ഉപകാരപ്രദം.

💭 ചിന്തിക്കുക: നിങ്ങൾക്ക് 20 വർഷത്തെ വിൽപ്പന ഡാറ്റ ഉണ്ടെങ്കിൽ, ഒരു കോളം ചാർട്ട് ഇപ്പോഴും നല്ല തിരഞ്ഞെടുപ്പാണോ? എന്തുകൊണ്ട്/എന്തുകൊണ്ട് അല്ല?
സൂചനകൾ: വളരെയധികം കോളങ്ങൾ ചാർട്ടിനെ അലങ്കോലപ്പെടുത്തുന്നു. ദീർഘകാല ശ്രേണിക്ക് ഒരു ലൈൻ ചാർട്ട് നല്ലതാണ്.

Important Exam Questions – Chapter 4 (2018–2024 & Textbook)

Q1 (2018 Mar – 1 Mark): In most Spread Sheets Charts and Graphs are available in ______ tab.
Answer: Insert.

Q2 (2018 Say – 1 Mark): A Spreadsheet '3D' chart has :
(a) 'X' axis (b) Y axis (c) 'Z' axis (d) All of these
Answer: (d) All of these.

Q3 (2019 Mar – 1 Mark): Can you help Mr. Ajith Kumar by pointing out the missing steps to create a chart in Spread Sheet from the following: Enter the data in cells, Select the data, Finish.
Answer: Missing step: Click on 'Insert' menu and choose 'Chart'.

Q4 (2019 Say & 2022 Mar – 1 Mark): A chart which displays data in rings is a
(a) Pie Chart (b) Column Chart (c) Radar Chart (d) Doughnut Chart
Answer: (d) Doughnut Chart.

Q5 (TE Questions – 1 Mark): Line chart is used to display:
(a) information about the frequency of different quantities
(b) trends over a period of time
(c) percentage of data
(d) data in vertical bars
Answer: (b) trends over a period of time.

Q6 (TE Questions – 1 Mark): To fill the chart area, double-click the chart and select:
(a) Chart wall (b) Data Range (c) Chart area (d) Titles
Answer: (a) Chart wall.

Q7 (TE Questions – 1 Mark): Find the odd one out:
(a) Normal pie chart (b) Donut chart (c) Exploded donut chart (d) Bar chart
Answer: (d) Bar chart (all others are variations of pie/donut).

Q8 (2018 Mar & 2021 Mar – 2 Marks): Name Four elements of a Spread Sheet graph or Chart.
Answer: 1. Chart Title 2. Axis (X-axis & Y-axis) 3. Data Series 4. Legend 5. Plot Area 6. Gridlines (any four).

Q9 (2018 Say & 2021 Mar – 2 Marks): Name any four types of charts available in a Spreadsheet software.
Answer: Column Chart, Bar Chart, Line Chart, Pie Chart, Area Chart, Doughnut Chart, Scatter Chart (any four).

Q10 (2019 Say – 2 Marks): Identify the name of charts mentioned in the following:
(a) Charts with vertical bars.
(b) Charts with horizontal bars.
Answer: (a) Column Chart (b) Bar Chart.

Q11 (2021 Say, 2022 Mar & 2022 Say – 2 Marks): Write any Two advantages of Charts and Graphs.
Answer: 1. Make data easy to understand and visually appealing. 2. Allow quick analysis and comparison of data points. 3. Help in identifying trends and patterns easily.

Q12 (TE Questions – 2 Marks): Explain the suitability of a column chart.
Answer: Column charts are ideal for comparing several items within a specific range of values. Categories are on X‑axis, values on Y‑axis. They work well for showing sales figures, exam scores, branch performance, etc.

Q13 (TE Questions – 2 Marks): Show the steps for creating a chart.
Answer: 1. Enter data with headers. 2. Select data range. 3. Insert → Chart. 4. Choose chart type. 5. Verify data range (First row/column as label). 6. Finish.

Q14 (TE Questions – 2 Marks): Illustrate and explain the elements of a chart.
Answer: Chart Area (entire region), Plot Area (graph area), Axes (X,Y,Z), Data Labels (values), Gridlines (guides), Legend (colour key), Chart Title, Axis Titles.

Q15 (TE Questions – 2 Marks): Compare 2D chart and 3D chart.
Answer: 2D charts have two dimensions (X,Y) – flat, accurate for reading values. 3D charts add depth (Z axis) – visually attractive but may distort data perception. Use 2D for analysis, 3D sparingly for presentations.

Q16 (TE Questions – 2 Marks): List out the advantages of charts and graphs in business applications.
Answer: Visual appeal, easy data reading, quick analysis, trend identification, fast comprehension, large data volume presentation, effective communication.

Q17 (TE Questions – 2 Marks): Mr. Abhijith wants to move the title of a chart to a new location, can you help him in this regard.
Answer: Yes – double‑click the chart to activate it, then click on the title to select it, and drag it to the desired location. You can also use the Format menu to align it precisely.

🔍 ഈ അധ്യായത്തിലെ എല്ലാ ചാർട്ട് തരങ്ങളും അവയുടെ സവിശേഷതകളും ഉദാഹരണങ്ങളും ഉൾപ്പെടുത്തിയിരിക്കുന്നു. ഓരോ ചാർട്ടും LibreOffice Calc‑ൽ പരിശീലിക്കുക.

SimonMash.com | Kerala Plus One & Plus Two Study Notes, Question Papers, Answer Keys, Resources