Make your Excel chart more appealing

In Excel, if you want to make a chart as shown in the diagram, please look down.

1. Prepare a small picture of the size of the 50x50 to match the content of the chart.

2. Start Excel 2002 (other version please follow the operation), open the corresponding file, the normal steps to produce a normal chart (from the final effect, it is recommended to use "column chart" or "bar chart" form).

3. Right-click on any of the columns, and in the shortcut menu that pops up, select the Format data series option to open the Data Series Format dialog box.

4. In the Pattern tab, click the Fill Effect button, and open the Fill Effect dialog box.

5. Switch to the "Picture" tab, click the Select Picture button, open the Select Picture dialog box, navigate to the folder where the picture is located, select the picture, press the Insert button to return to the Fill Effect dialog box, select the Cascade and Zoom option, and then click OK to exit.

Tip: The "cascade and Zoom" option in the box below the value set too small (such as "2") or too large (such as "20"), the picture displayed in the chart is too small or too large to affect the perception of the chart, it is recommended to use its default value of "10" directly.

6. Again, the normal way to decorate the chart properly, a very attractive chart will appear in front of you.

Tip: This method also applies to the charts in Word 2002 and PowerPoint 2002, so please follow them.

Demographic statistics for 2002 of a city