My logic is like this, worksheet A is listed as the data source. The first step is to use the code to find the maximum, minimum, and range in the data. Then manually enter the starting number and group distance of the data split point according to the actual situation. The second step uses code codes to automatically generate grouping intervals, the data frequency contained in each group interval, and then the frequency and frequency divided by the value of the group distance. Like my own complex and cumbersome code generation effect. The third step uses the interval as the abscissa and the frequency divided by the group distance as the ordinate to draw a frequency distribution histogram. Each column of the picture is required to have no spacing next to each other, and each column has a different color. The graph you just made with the pivot table is very good, the effect is best if the columns have different colors next to each other. Thank you!