Micro Notes - CHAPTER -4 GRAPHS AND CHARTS FOR BUSINESS

INTRODUCTION
Charts turn rows of numbers into pictures for faster understanding and visual impact.
TYPES OF CHARTS IN SPREADSHEET
1. Column Chart: Vertical bars comparing categories (sales of 4 products).
2. Line Chart: Shows trends over time (share price, website visitors).
3. Pie Chart: One data series as % of total (family budget, market share).
4. Bar Chart: Horizontal bars – useful when category names are long.
5. Area Chart: Line chart with filled area – emphasises magnitude of change.
6. Scatter Chart (XY): Shows relationship between two variables (ads vs sales).
7. Bubble Chart: Scatter with bubble size = third variable (price, sales, profit).
8. Radar Chart (Net Chart): Spider web – compares items across criteria (employee skills).
9. Stock Chart: Shows high, low, open, close prices for stocks.
10. Column & Line Chart: Combined – columns for actual, line for target.
11. Exploded Pie Chart: One slice pulled out to highlight it.
12. Donut Chart: Pie with hole – can show multiple data series as rings.
13. Exploded Donut Chart: Donut with all slices exploded.
STEPS TO CREATE CHARTS IN LIBREOFFICE CALC
1. Enter data with headers. 2. Select data. 3. Insert → Chart → Choose type. 4. Tick "First row as label" & "First column as label". 5. Finish.
Exam Q (2019 Mar): Missing step from "Enter data → Select data → Finish"? Ans: Click 'Insert' menu and choose 'Chart'.
ELEMENTS OF A CHART
Chart Text: Titles (Chart, Axis). Chart Area: Entire region. Plot Area: Where data is plotted. Axis: X, Y, Z reference lines. Data Labels: Values of data points. Gridlines: Optional guides. Legend: Colour/symbol indicators.
Exam Q (2018 Mar, 2021 Mar – 2 Marks): Name four elements? Ans: Chart Title, Axis, Data Series, Legend, Plot Area, Gridlines (any four).
FORMATTING CHARTS
Double-click chart → Use Insert/Format tabs to add/edit Titles, Legend, Data Labels, Gridlines.
Resize: Click chart → Drag handles on border.
Move: Drag chart by mouse or Cut/Paste.
2D vs 3D CHARTS
2D: Flat (X,Y) – accurate for reading values.
3D: Adds depth (Z axis) – visually attractive but may distort perception.
Exam Q (2018 Say – 1 Mark): 3D chart has? Ans: All of these (X, Y, Z axes).
ADVANTAGES OF CHARTS & GRAPHS
Visually appealing, Easy to read, Quick analysis, Trend identification, Fast comprehension, Large data volume presentation.
Exam Q (2021 Say, 2022 Mar, 2022 Say – 2 Marks): Any two advantages? Ans: 1. Make data easy to understand and visually appealing. 2. Allow quick analysis and comparison.
IMPORTANT EXAM QUESTIONS (CHAPTER 4 – 2018 to 2024)
Q1 (2018 Mar): Charts & Graphs available in which tab? Ans: Insert.
Q2 (2018 Say): 3D chart has which axes? Ans: All (X, Y, Z).
Q3 (2019 Mar): Missing step to create chart? Ans: Click Insert → Chart.
Q4 (2019 Say & 2022 Mar): Chart displaying data in rings? Ans: Doughnut Chart.
Q5 (TE Q): Line chart used for? Ans: Trends over time.
Q6 (TE Q): To fill chart area, double-click and select? Ans: Chart wall.
Q7 (TE Q): Odd one: Normal pie, Donut, Exploded donut, Bar chart? Ans: Bar chart.
Q8 (2018 Mar, 2021 Mar – 2 Marks): Four chart elements? Ans: Chart Title, Axis, Data Series, Legend, Plot Area, Gridlines (any four).
Q9 (2018 Say, 2021 Mar – 2 Marks): Four chart types? Ans: Column, Bar, Line, Pie, Area, Doughnut, Scatter (any four).
Q10 (2019 Say – 2 Marks): Charts with vertical bars? Ans: Column Chart. Horizontal bars? Ans: Bar Chart.
Q11 (2021 Say, 2022 Mar, 2022 Say – 2 Marks): Two advantages? Ans: 1. Easy to understand & visually appealing. 2. Quick analysis & comparison.
Q12 (TE Q – 2 Marks): Column chart suitability? Ans: Comparing items within a range (sales, scores, branch performance).
Q13 (TE Q – 2 Marks): Steps to create chart? Ans: 1. Enter data with headers. 2. Select data. 3. Insert → Chart. 4. Choose type. 5. Verify labels. 6. Finish.
Q14 (TE Q – 2 Marks): Chart elements explain? Ans: Chart Area (entire), Plot Area (graph), Axes (X,Y), Data Labels (values), Gridlines (guides), Legend (key), Titles.
Q15 (TE Q – 2 Marks): 2D vs 3D comparison? Ans: 2D flat & accurate; 3D adds depth, visually appealing but may distort.
Q16 (TE Q – 2 Marks): Advantages in business? Ans: Visual appeal, quick analysis, trend identification, large data presentation.
Q17 (TE Q – 2 Marks): Move chart title? Ans: Double-click chart → Click title → Drag to new location.