Excel offers a variety of chart types, each suited for different kinds of data and analysis goals. Your choice impacts how well your audience understands the insights you're presenting.

Gantt Chart is one of the tools used for project planning & management. Learn how to create & use Gann Chart on Microsoft Excel.

Select Insert from the menu, and in the charts group, select the type of chart you want to add to the report sheet. In the Chart Design menu, in the Data group, select Select Data.

Select the sparklines; that’s H3:H8. Click the Sparkline contextual tab. In the Style group, click the Marker Color dropdown and choose Negative Points (Figure B); I chose red.