Question

if I want to make sparkline in exel so what is the formula I want it in green and A4:B4​

Answer 1

Answer:

Add a Sparkline

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

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

Select cells in the row and OK in menu.

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

Format a Sparkline chart

Select the Sparkline chart.

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.

Answer 2

$\tt\huge\purple{hello!!!}$

HERE IS UR ANSWER

$_____________________________$

1. Select the data range for the sparklines.
2. On the Insert tab, click Sparklines, and then click the kind of sparkline that you want.
3. In the Insert Sparklines dialog box, notice that the first box is already filled based on your selection in step 1.