How do I get a chart to appear in Excel cells

First, open the Excel table, and then left-click to select the cells that you want to create a mini chart for. Switch to the Insert Feature tab, in the Sparkline group, click a miniature chart type (there are currently only 3 Sparkline: Stitches, column, Profit and Loss) buttons (Here you choose Column Chart), Open the Create Sparkline dialog box. The following figure:

Step two, using the collapse button to the right of the position range, select the cell that displays the mini chart, click OK, and the sparkline is automatically inserted into the cell. The following figure:

Select the cell that contains the mini chart, and the software will expand the Sparkline Tools/Design tab, and you can make more changes to the Sparkline by using the related function buttons.