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.

Select the data range, click the Insert tab, then click the Insert Column or Bar button in the Chart group. In the 2-D Bar section, select the choose the Stacked Bar option from the menu.

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.

As you probably already know, to create a chart, you select the data you want visualized and go to the Insert tab on the ribbon. In the Charts group, select the type of chart you want to create. From ...

Now, to create a non-contiguous selection, select B3:B7, the counties. Hold down the Ctrl key and select E3:E7. To insert the filled map, click the Insert tab and then click Maps in the Charts group.

Right-click on the chart, select Select Data, and adjust the order if needed. Update Chart Elements: Check that all chart elements like labels and legends are correctly displayed.

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.

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.