From the course: Microsoft Office Specialist: Expert (Office 365 and Office 2019) Cert Prep

Unlock the full course today

Join today to access over 25,200 courses taught by industry experts.

Create and modify histogram and map charts

Create and modify histogram and map charts

From the course: Microsoft Office Specialist: Expert (Office 365 and Office 2019) Cert Prep

Start my 1-month free trial Buy for my team

Create and modify histogram and map charts

“

- [Instructor] In this video, we'll take a look at two more newer charts in Excel 2019. We'll take a look at the histogram and map charts. The histogram chart is a columned chart that will show the frequency of data, and what we'll be looking at is the commission rate for each of our salespeople. We have three categories. Maybe four, we'll take a look. The data that we analyzed is assigned to a bin, and we can determine how many bins we want to show to display our information. The second one we'll look at is a map chart. It's a cool feature, but I find that it's really limited. For instance, it doesn't include city data, so you can show, for instance, a map of the United States and how many sales you have in Texas, but it won't drill down any further than that. Well, let's go ahead and take a look at histogram and map charts. First, the histogram. We have a dataset that has the commission rate for each of our employees…

Contents