The first step is to display the data analysis button. File-> Options->; Add-in-> Excel add-in-> Data analysis takes time. After being selected, you can find the data analysis button on the data page of the menu bar, as shown below.
Step two, start painting. Take the following purchase data as an example, and make a purchase price histogram (gray area G4:G97) according to the price interval (L4:L 1 1).
1, purchase data
price range
2. Start drawing and click the data-> Data analysis->; bar chart
Input Range Enter G4:G97, the data source of purchase price.
Bin Rang input L4:L 1 1, price range.
The output option is the location of the output histogram, and there are three options (this is not detailed).
Pareto test
Cumulative percentage check
Chart output check
3. Click OK to display the histogram.