Office hacks: creative combinations Play PPT combination chart

In order to make visual expressions, we often need to add various charts in PPT. However, when using Microsoft PowerPoint, if we simply insert the built-in chart style of the software, it will inevitably look monotonous, and then we need to creatively use the existing functions of the software to create extraordinary PPT charts.

Simple overlay to create a combination of graphics

Because PPT is mainly used for display, it requires high value for charts. For some charts, in order to be more visually appealing, we can insert them by way of a combination of charts. The production of combined charts in Excel is more complicated, while in PPT the chart is a graphical element that can be achieved by simple superimposition.

For example, in order to show the changes in sales data, we can insert a line chart in Excel, but a simple line chart is more monotonous, at this time you can insert a line chart + bar chart combination to achieve. First of all, enter the data in Excel to generate line graphs, in order to make the line effect more beautiful, select the line graph right-click and select “Set Data Series Format ¡ú Line”, check the bottom of the “smooth line”, the line will be converted into a smooth curve effect. Then remove the title of the icon, the grid, values and other irrelevant elements, so as to get a smooth curve (Figure 1).


Figure 1 Smoothing curve production

Continue to select the data to insert the bar chart data, as above also remove the title, grid, values and other irrelevant elements, in setting the data series format select “Series Options”, set the series overlap to 0%, the gap width is also set to 0%, the bar chart will be connected as an area chart (Figure 2).


Figure 2 Bar graph settings

Hold down the Ctrl key to select the above two graphics in turn and paste them into the PPT, click “Start → Select Pane”, move the smooth curve to the top of the bar chart, and move its position to form a combination of images. In order to make the curve more eye-catching, you can set its width to 20 pounds, so that a chart composed of curves and bars is completed (Figure 3).


Figure 3 Combined graphs

Do-it-yourself Combination Charts

The above method allows you to create any combination of charts, but as you can see it is a simple combination, the chart is not beautiful, and the curves do not fit seamlessly into the bar area. If you want to make the combination of charts more beautiful, we can use the polygon tool to create their own.

As above, first in Excel to create a line area map (here the line can not be changed into a smooth curve), the generated line area map inserted into the PPT as prompted, click “Insert → Line Pass → Any Polygon”, and then draw a polygon tool as prompted (just click on the starting point of the line area map can be), the polygon filled with red display (Figure 4).


Figure 4 drawing polygon

The original inserted area map to delete, select the two vertices of the home of the curve pulled up to turn it into a smooth curve, the same reference to the shape of the combination of the previous example, the other vertices also into a smooth curve, so that a “smooth curve + area” combination of charts is complete, the combination of this effect is not more beautiful (Figure 5).


Figure 5 Polygons draw smooth curves

You can see that by using self-drawing polygons, we can turn the original uneditable charts into vector graphics, which can be edited at will in PPT. For special graphics like maps, dashboards, etc., we can use this method to convert them.

Use gradient fill to make a combination chart

In order to achieve better visualization in PPT, we often use some combination of icons to visually represent the scale. For this kind of combination charts, it is easy to use PPT’s gradient fill.

For example, we need to use a human figure to represent the ratio of white-collar subhealth (healthy:subhealthy=25%:75%). Click “Insert→Shape” in the PPT, insert a circle, rounded rectangle and rectangle in turn, and combine them (pay attention to the ratio of each other). After completing the combination of the human figure, select the three shapes in turn, click “Drawing Format → Shape → Union” to combine them into a human pattern (Figure 6).


Figure 6 Create a human figure

Select the above combination of graphics, right-click and select “Set Shape Format”, choose “Gradient Fill” for the fill, then delete all the extra gradient apertures and keep only two gradient apertures, and set the color of the front and back apertures to gray and striking red (corresponding to (corresponding to the normal and subhealthy markers), drag the gray gradient aperture, and set the position to 25% (Figure 7).


Figure 7 Set the position of the gradient aperture

The operation is the same as above, continue dragging the red gradient aperture on the right side and set its position to 25% as well. This way a small person composed of gray and red is completed, and the colors indicate the percentage of normal and sub-health respectively. Finally, the chart is slightly beautified, fill the slide background, add explanatory text, so that the combination of the chart is not more intuitive expression of the PPT theme (Figure 8).


Fig. 8 Combination chart formed by gradient filling

For example, in the above example, we can first copy 10 figures of the same shape and arrange them in order, then copy and paste the third figure as a picture and place it above the original figure and overlap it, then use the crop tool to cut it in half and fill the rest of the chart with red, so that we can also visually see the proportion of subhealth people (Figure 9). This way, the proportion of subhealthy people can also be seen visually (Figure 9).


Figure 9 Percentage by cropping method

Leave a Comment