Create funnel charts and 2D maps in Excel

- [Instructor] When you need to show stages in a process here in Excel 2019, there's a new funnel chart that'll come in handy. And when you need to compare values and show categories across geographical regions, there's a new 2D map as well. We're going to explore with some data. You can see I have some in a table and some just sitting here on the sheet. Let's start with a funnel chart. We'll select some content. I'm gonna go with State Sales for 2018, and from here when we go to insert we see at the chart section where we can select from a variety of charts.

But recommended charts will only show charts that would work with the data we selected. And when we click this you'll notice, well there's a map, clicking it will show what the map might look like if we were to select it we'll come back to that though, right down at the bottom is our funnel chart. Selecting it tells you a little bit about it and gives you a nice little preview here of what it's going to look like. So when we click okay, it's inserted. We can double-click the chart title to get in there and give it a title, like Top Sales by State, and analyze the data as you can see getting smaller and smaller as it works its way down.

Of course there are different design options here when we go to our chart styles and hover over them we get to see what that might look like before actually making the selection. I'm gonna go with this one. Shows the data right inside the bars, click in the outside to see the end result deselected. Kinda cool! Right, let's select it and delete it with the delete key on the keyboard, and check out the 2D maps. Again, this'll work with table data, like we see here, as well as data that's sitting on the sheet.

Again, we can select, if we want, the labels for State and Sales, or just go down to the actual data itself and select it. Now when we go to insert, you'll notice maps does appear here all by itself, and if we go to recommended charts it too will show up here as one that will work with the data we selected. Again, we can select this data which is simply States in the US, and see that the map over here is a map of the United States, and the various States where we have data are highlighted, in this case using the default shades of blue, the darker indicating the greater values.

Let's click cancel and go to our table data where we see countries listed here. Let's click and drag from USA down to Canada, we'll live Australia out for now, and go up to recommended charts, and check out the 2D map. It looks different, it's a map of North America this time. Where we see the US including Alaska selected, there's Canada and Mexico. And again, the darker values represent the bigger values. When we click cancel and go back to our data and select everything including Australia, this time when we go to recommended charts, check out the map.

It's a world map now, because we have countries outside North America being selected. You can see Australia there. So if we were to choose this one by clicking okay, we'll see that 2D map, we have our chart styles up above, we can change the colors just like we did with the funnel chart. That's a quick look at the 2D maps and funnel charts available here in Excel 2019.