From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create and modify histogram and map charts

Create and modify histogram and map charts

From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

Start my 1-month free trial

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