There are other charts available in Excel other than the most common ones mentioned, such as the Treemap chart. A Treemap chart provides a hierarchical view of data and makes it easy to spot patterns.

To make McKinsey charts interactive, integrate dynamic Excel formulas that update the chart in real-time as the underlying data changes, transforming static visuals into interactive tools.

Step 2: Make an Excel Bar Chart. To start to visualize your data, you’ll first create an Excel stacked bar chart from the spreadsheet. Select the “Start date” column, so it’s highlighted.

This is where you can make the following changes to your chart: Add chart labels (also known as elements), like axis labels, gridlines, or a legend.; Choose a label layout if you don't have time ...

Fortunately, you can customize the chart a bit if you don’t care for the original design. Figure D. The people chart is based on the survey data in the Table. How to customize Excel’s people chart ...

Excel doesn’t offer a floating bar chart of its own, and finding the option isn’t intuitive. First, we’ll create a line chart, and that chart type offers floating bars.

Lollipop charts and bar charts are similar; they make comparisons between different items and categories. Follow the steps below to make a Lollipop chart: Launch Excel > Select the range of cells.