From the course: Excel Tips Weekly

Unlock this course with a free trial

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

Comparing the Data Analysis Histogram feature and Excel's Histogram chart

Comparing the Data Analysis Histogram feature and Excel's Histogram chart - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Comparing the Data Analysis Histogram feature and Excel's Histogram chart

“

- [Instructor] On this worksheet, we're seeing 2 two different kinds of charts 3 that are referred to as histogram charts. 4 Excel has any number of different charts, 5 and typically when you create charts, 6 you go to the insert tab in the ribbon. 7 Histogram, by the way, is found under 8 a statistic chart right here. 9 But there's another way to create a histogram. 10 It also involves using what's called an add-in 11 and a pretty powerful add-in 12 referred to as the analysis tool pack. 13 If you click on the data tab in the ribbon 14 off to the right, you might see an additional panel out here 15 and an additional group called data analysis. 16 What we're about to do need only be done once, 17 but I'm going to click on the file tab 18 in the ribbon menu system, go down to options, 19 add-ins, 20 and you'll see the term analysis tool pack here 21 and down below manage, make sure it says Excel add-ins, 22 go. 23…

Contents