Shulou(Shulou.com)06/01 Report--

This article mainly introduces "how to realize the slippery bead map in Excel". In the daily operation, I believe that many people have doubts about how to realize the slippery bead map in Excel. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "how to realize slippery bead map in Excel". Next, please follow the editor to study!

1 slider bead chart

The slippery bead chart is usually used in business weeks. it can be used to compare the dimensions between different groups. in the chart, the horizontal bar is the change of the bar, while the two slider beads can be realized by scatter charts. the following is a real-time comparison of the single volume of different types of products in the same period last year and today.

2 Operation steps

Step 1: data selection. Two sets of random numbers are generated by using the RANDBETWEEN function, which represents the generation of random numbers from 0 to 100.

= RANDBETWEEN (0100) adds auxiliary series, where X is the maximum value in the original data plus 5, and the formula is: = MAX ($C$4:$D$11) + 5Y is the number of categories plus 0.5, so that the scatter chart can match the bar chart, the formula is: = COUNTA (B4:B11)-0.5

Step 2: horizontal cluster bar chart. Select the first four columns of data, then insert a horizontal cluster bar chart, and select the first chart.

Step 2: change the chart type. Right-click any bar chart and select change Series Chart Type.

Step 3: change the chart type. Change the chart type for the same period last year and today to scatter chart.

Step 4: select the data. Right-click to select data.

Step 5: select the data. Select the series for the same period last year and click Edit.

Step 6: select the data. The X axis series values select the same period last year data series, and the Y axis series values select the auxiliary column Y data series. Step 7: select the data. Select Today's Real time series and click Edit. Step 8: select the data. X-axis series values select today's real-time data series, Y-axis series values select auxiliary column Y data series. The first version of the chart is shown in the figure: step 9: graphic beautification. In the axis options, set the label position to high. Step 10: graphic beautification. Set the data series format, in the tag, set to no fill, the border is set to red solid line, the width is 2 pounds. At this point, the study on "how to achieve the slippery bead map in Excel" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.