Ravindra BagaleCourses & study guides मराठी Track your progress

8. Charts

8.3 Line and Area Charts

By Last updated:

Line – trends over time (many periods). Area – trend plus the size of the total; stacked area shows how parts contribute over time.

Worked example. Line chart of Pune, Nashik and Nagpur sales Jul–Dec: the two peaks (Sep, Nov) are obvious. Add a Trendline (+ › Trendline › Linear) on Pune to show the underlying growth, or a 2-period moving average to smooth festival spikes.

Steps in Excel

  1. Select A1:D7 › Insert › Charts › Line or Area › Line with Markers.
  2. Highlight Pune: format the Pune line thicker and dark green; make the others light grey.
  3. Label the last point only: click the Dec point twice › + › Data Label.
  4. For gaps in data: Chart Design › Select Data › Hidden and Empty Cells › Show empty cells as Gaps / Zero / Connect with line.

Ravindra Bagale's Tip

Many students make the mistake of using a line chart for categories (cities) – how can there be a "line" from Pune to Nashik? A line is only for things that come in sequence (time). And if you put 6–7 lines in one chart, it becomes "spaghetti" – highlight one or two and make the rest grey.

Worked example — line and area charts

Why

Meera Joshi in Pune and Carlos Rivera abroad both need a clear, repeatable way to use line and area charts on a BrightLedger Finance sheet without breaking totals.

What

Line And Area Charts is the Excel idea this page teaches. We will walk one tiny example end to end.

How

  1. Open a blank sheet. In A1 type a short label for line and area charts.
  2. Enter a small made-up value for Meera Joshi using € where money appears.
  3. Add a second value for Carlos Rivera using $ so you see mixed currencies stay numeric.
  4. Apply the method from this lesson step by step (menu or formula as shown above).
  5. Check the result still works inside SUM or a simple check cell.

Formula / action

Follow the formula or ribbon steps shown in this lesson (keep values numeric).
Result: The demo cell shows the expected result for BrightLedger Finance's sample row.
Meaning: Once line and area charts is correct on one row, copy the same pattern down the column.

Practice tasks (10+)

Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.

1. Rebuild the smallest example of line and area charts on a blank sheet for NovaCraft Tools.

Hint: Use only the steps on this page. Keep numbers numeric.

2. Change one input for Priya Deshmukh and confirm the result updates.

Hint: If the result is stuck, check absolute vs relative references.

3. Repeat the same steps with a £ or € value for Oliver Bennett.

Hint: Formatting must not break SUM.

4. Write the result meaning in one plain sentence next to the cell.

Hint: Imagine explaining it to a new joiners.

5. Add a second row and fill the method down.

Hint: Double-click the fill handle if the pattern is consistent.

6. Break the example on purpose, then fix it using this lesson.

Hint: Common break: text instead of a number.

7. Apply line and area charts to a 5-row made-up NovaCraft Tools table.

Hint: Keep column headers clear.

8. Check your answer with a simple total or COUNT.

Hint: A wrong total usually means a format or key mismatch.

9. Swap ₹ and $ on one column and re-check totals.

Hint: Stored values stay the same; only the display changes.

10. List two mistakes beginners make with line and area charts.

Hint: Look back at the tip box on this page.

11. Teach the steps out loud in under one minute.

Hint: Why → What → How.

12. Save the sheet as NovaCraftTo_practice.xlsx.

Hint: Use a clear file name for class.

Loading practice tasks...

  1. Total deals won (Easy): Add up Deals won in the "Deals won" column.
  2. Average avg (Easy): Average of the Avg deal value (£) column, rounded to 2 decimals.
  3. Rows in North (Easy): How many rows have Category/group "North"? (the "Region" column)
  4. Largest deals won (Easy): The largest value in the "Deals won" column.
  5. Deals won for North (Medium): Total of the Deals won column where Region is "North".
  6. North in Leeds (Medium): Total of the Deals won column where Region is "North" and City is "Leeds".
  7. Best in North (Medium): Largest value in the "Avg deal value (£)" column where "Region" is "North".
  8. Value of row 2 (Medium): Multiply the first-row Deals won by the first-row Avg deal value (£).
  9. Look up Chloe Dubois (Medium): The Deals won for "Chloe Dubois" (use a lookup on the "Name" column).
  10. Total value (Hard): Sum of "Deals won" times "Avg deal value (£)" for all rows.
  11. Share of North (Hard): Share of the "Deals won" column that is "North", rounded to 3 decimals.
  12. Total "Deals won" for South (Hard): Add up the "Deals won" column for the rows where "Region" is "South".
  13. Above average? (Hard): "Above" if the "Avg deal value (£)" value in the first row is above the average of the "Avg deal value (£)" column, else "Below".

See all practice tasks in the Task Hub →

Quick revision cards

Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.

Revision card 1: What is Line And Area Charts?
Card 1: What is Line And Area Charts? · Download PNG
Revision card 2: Tiny example — Line And Area Charts
Card 2: Tiny example — Line And Area Charts · Download PNG
Revision card 3: Checklist — Line And Area Charts
Card 3: Checklist — Line And Area Charts · Download PNG