The operation process of using formulas to create star charts in Excel

Are you still worried about how to make a star chart? PHP editor Strawberry has brought you a detailed tutorial, introducing the steps to easily create a star chart using Excel formulas. Come and find out!

As shown in the picture, I want to use the formula in the size column to create a star chart to compare the size of the rating data in column C.

Before operating through formulas, you must first know how to enter a five-pointed star, click Insert, and then select more symbols

In the pop-up dialog box for inserting special symbols , select the special symbol, then select the solid five-pointed star, click OK

Select the solid five-pointed star, click copy and save

in the cell In D3, enter the formula =REPT("★",C3/10), and then press Enter

After pressing Enter, a star chart based on data will appear. Pull down the cell to copy the formula, intuitively The star chart reflecting the size of the data is completed

The above is the detailed content of The operation process of using formulas to create star charts in Excel. For more information, please follow other related articles on the PHP Chinese website!