MS Excel in Bangla > Charts

How to Use Spark lines

20.2k

Sparklines are little charts that may be placed into single worksheet cells to visually depict and highlight a pattern in your data. Sparklines can emphasise important topics such as seasonal variations or economic cycles by using a distinct colour for the maximum and minimum values.

Show data trends with sparklines.

  • Choose a blank cell at the conclusion of a data row.
  • Choose Insert and a Sparkline type such as Line or Column.
  • In the menu, select cells in the row and click OK.
  • more rows of information? To add a Sparkline to each row, drag the handle.

To insert a line sparkline in Excel, follow these steps:

  • Choose the cell where you want the sparkline to appear.
  • Select the Insert tab from the drop-down menu.
  • Select the Line option from the Sparklines group.
  • Select the data range in the 'Create Sparklines' dialogue box (A2:F2 in this example).
  • Click OK.

Line, Column, and Win/Loss are the three different forms of sparklines. Line and column charts have the same functionality as line and column charts. Win/Loss is similar to Column, except it simply shows whether each value is positive or negative, rather than how high or low it is.

A stacked column chart: A. layers data segments in one column on top of one other, with each data series type represented by a distinct colour.

Learner's Ratings

4.7

Overall Rating

  • 82%
  • 11%
  • 4%
  • 3%
  • 0%

Reviews

S
SUSANTA BARMAN
4

best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video

P
Prabhat Yadav
5

Superb and amazing 😍🤩 enjoyable experience.

P
pritam chakraborty
5

very good

S
Sudip Sadhukhan
5

Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you

S
sadananda basak
5

Teaching technique is easy to understand. Thanks.

J
Joydeep
5

nice

U
Uttam Nandi
5

Very nice teaching.

R
RABIN DEY
5

REALLY HELPFUL COURSE

S
Subhasis Bosu
5

good

A
Anamul Huq
5

This is helpful how are zero to intermediate level.

Show More
Course Content

  1. How to Work with Menu Bar
    5m 39s
  2. How to use LearnVern
    3m 20s
  3. What is Quick Access Toolbar and How to Work with it
    6m 33s
  4. How to Work with Formula Bar
    2m 35s
  5. What is Status Bar and How to Work With it
    5m 33s
  6. How to Navigate within Sheet and Workbook
    3m
  7. How to use Shortcuts
    4m 3s
  8. What is Format Painter and How to work with it
    2m 25s

  1. How to Enter Data in MS Excel
    4m 58s
  2. How to Use Autofill Functionality
    5m 32s
  3. How to Enter Date-Time
    6m 11s
  4. How to Use Undo-Redo
    5m 17s
  5. How to Work With Comments in MS Excel
    3m 29s
  6. How to Save Workbook in MS Excel
    4m 16s

  1. How to Create Formula in MS Excel
    7m 40s
  2. How to Copy Formula in MS Excel
    3m 31s
  3. How to Use Till Date Profit Formula
    3m 37s
  4. How to Work with Percentage Change Calculation
    5m 22s
  5. How to Use Absolute Value
    6m
  6. How to Use Sum Average
    5m 28s
  7. Which are the Common Functions
    7m 39s

  1. How to Format the Fonts
    3m 41s
  2. How to Adjust Rows and Columns
    3m 57s
  3. How to Use Alignment
    7m 3s
  4. How to Format the Borders
    2m 56s
  5. How to Format Numbers
    3m 52s
  6. How to Format Date-Time
    9m
  7. How to Use Conditional Formatting
    9m 6s
  8. How to Format Tables
    9m 1s
  9. How to Format Shapes
    6m 49s

  1. How to Resize Row & Column
    7m 2s
  2. How to Hide-Unhide Row & Column
    5m 23s
  3. How to Copy ,Move & Insert Data
    5m 28s
  4. How to Find and Replace Data
    6m 32s

  1. How to Print
    8m 33s
  2. What is Page Break Preview & How to Set Page
    5m 21s
  3. How to Set Page
    4m 57s

  1. How to create Charts
    7m 10s
  2. Which are the different types of Chart
    5m 37s
  3. How to Format Charts
    6m 31s
  4. Which are the Chart Elements
    7m 42s
  5. How to Use Spark lines
    7m 54s

  1. How to Freeze-Unfreeze the Row & Column
    7m 26s
  2. How to Split the Sheet
    6m 50s
  3. How to Use Outline
    6m 59s

  1. How to Manage Multiple Workbook
    6m 37s
  2. How to Use Rename Insert hide unhide sheets
    4m 38s
  3. How to Copy & Delete Sheets
    6m 30s
  4. How to Use Formula
    9m 4s
  5. How to Edit Links
    9m 12s

  1. What is IF Condition and How to Use it
    6m 25s
  2. What is VLOOKUP and How to Use It
    5m 59s
  3. What is VLOOKUP Exact
    4m 9s
  4. How to Use COUNT IF
    4m 23s

  1. How to Protect Sheet
    4m 52s
  2. How to Secure Workbook
    6m 7s
  3. How to Set Password in Workbook
    2m 19s
  4. How to Share Workbook
    3m 9s
  5. How to Track Changes
    5m 34s

  1. How to Perform Sorting
    6m 35s
  2. How to do Subtotals
    7m 26s
  3. How to Perform Filter
    5m 31s
  4. How to Spilt Data
    4m 20s
  5. How to Use Flash Fill
    3m 35s
  6. How to Remove Duplicate Data
    2m 34s
  7. How to Validate Data
    6m 51s

  1. How to Create Pivot Table in MS Excel
    11m 6s
  2. How to Manipulate Pivot Table
    8m 19s
  3. How to Add Slicers
    4m 36s
  4. How to Perform Grouping of Pivot Table
    4m 39s

  1. What is Macro And How to Use It
    7m 25s

  1. Assignment Q-1
    1m 10s
  2. Assignment Q-2
    21s
  3. Assignment Q-3
    34s
  4. Assignment Q-4
    50s
  5. Assignment Q-5
    48s
  6. Assignment Q-6
    37s
  7. Assignment Q-7
    47s
  8. Assignment Q-8
    45s
  9. Assignment Q-9
    37s
  10. Assignment Q-10
    32s
Enroll For Free