Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

How to create a Lollipop Chart in Excel Follow the steps below to make a Lollipop chart: Launch Excel > Select the range of cells. Click the Insert tab and click the Insert Column or Bar Chart button.

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.

Other versions of Excel may work differently. All the charts and underlying data are available in this Excel file. As you probably already know, to create a chart, you select the data you want ...

Open Excel and select your data that you want to visualize in the McKinsey chart. Go to the ‘Insert’ tab and click on ‘Waterfall’ or ‘Stock chart’ and then select ‘Waterfall’.