# How to make Sparkline Charts in Excel

Make Mini Charts in Excel | एक्सेल में मिनी चार्ट्स कैसे बनाये. In this excel tutorial you will lean how to make mini charts in excel . These mini excel charts are useful for data analysis and to make MIS reports in Excel. Download file link https://www.instamojo.com/Devika/mini-charts-in-excel/ Download More Practice Files from http://www.www.myelesson.org/downloads

1. Select a blank cell at the end of a row of data.

2. Select Insert and pick Sparkline type, like Line, or Column.

3. Select cells in the row and OK in menu.

4. More rows of data? Drag handle to add a Sparkline for each row.

## Format a Sparkline chart

1. Select the Sparkline chart.

2. Select Sparkline and then select an option.

• Select Line, Column, or Win/Loss to change the chart type.

• Check Markers to highlight individual values in the Sparkline chart.

• Select a Style for the Sparkline.

• Select Sparkline Color and the color.

• Select Sparkline Color > Weight to select the width of the Sparkline.

• Select Marker Color to change the color of the markers.

• If the data has positive and negative values, select Axis to show the axis.

** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel-https://youtu.be/KyMj8HEBNAk
Learn Basic Excel Skills For Beginners- https://youtu.be/3kNEv3s8TuA
Learn the Basic of Excel for Beginners -https://youtu.be/qeMSV9T1PoI
10 Most Used Excel Formula-https://youtu.be/2t3FDi98GBk
Learn Vlookup Formula For Beginners in Excel-https://youtu.be/vomClevScJQ
5 Excel Questions Asked in Job Interviews-https://youtu.be/7Iwx4AMdij8
Create Speedometer Chart In Excel-https://youtu.be/f6c93-fQlCs
Create Pareto Chart In Excel-https://youtu.be/2UdajrDMjRE
How to Create Dashboard in Excel-https://youtu.be/RM8T1eYBjQY