Current location - Recipe Complete Network - Catering training - How to do data analysis with PPT
How to do data analysis with PPT
Tool preparation

1.PPT2007 (original carrier)

2.EXCEL2007 (making charts)

3.Colorpix (color matching)

4. The system comes with drawing tools (screenshot)

5. Meitu Xiu Xiu (picture beautification)

Drawing steps

1.

Generally, the width of the data information map is between 400- 1000 pixels (100 pixels is about 3.53 cm), and the height depends on the specific content. If the content occupies several screens, it is better to be longer, so that after the post-production is completed, the redundant blank parts can be removed through screenshots. The specific size settings are as follows:

Then the background color of the main color can be determined by changing the theme of the slide, thus basically determining the background cloth of the data information map. Of course, you can also use some foreign tools to configure your favorite background images, such as stripemania, tartanmaker, bgpatterns and stripegenerator.

2. Content filling

Here, the whole data infographic is divided into three parts: infographic title, main content display and remarks, among which remarks can also be placed in the content display part. As for the theme and content display content, it depends entirely on personal needs, such as the series of "reading xx with one picture" circulating on the Internet.

The chart making of the content display part is not introduced in detail here. If you want EXCEL charts to be beautiful and novel, you can refer to the book How to Make EXCEL Charts by Liu Wanxiang. For the production of some specific charts, you can also refer to the relevant drawing summary in the chart collection blog. Here, it should be noted that:

EXCEL can enrich the choice of colors when drawing, and the colorpix gadget is recommended here.

The data information diagram makes the diagram as beautiful as possible, so the diagram filling can be replaced by some vivid pictures;

Before copying EXCEL pictures to PPT, try to convert the chart into a picture format to avoid distortion when resizing in PPT.

3. Style conversion (converting PPT into picture format)

A theme, a chart, after PPT is completed, save it as a picture format. It is not only the screenshot part of the attachment drawing tool that comes with Windows system that can cut off the edges and corners.

Treatment and beautification

The tool for beautification is Meitu Xiu Xiu, and its beautification function is mainly used here to fine-tune the picture background.

A case

Post a case of data information diagram made with PPT.