Office hacks: Use the graphical chart of your choice to make your work stand out

Whether the slides are eye-catching and the charts are beautiful has a great impact on the presentation effect. We usually design slide backgrounds or charts, is often directly applied to the PPT or Excel to provide some template, which is not wrong, but there will always be a uniform or stereotypical feeling. If you can make good use of optional graphics or optional charts, and the effect of the necessary settings, you can make a chic presentation background or chart.

Use optional graphics to make the background staggered

If the PPT comes with a good use of the fill effect of the optional graphics, and then overlay them accordingly, you can make a staggered background effect (Figure 1).

1821A-CLBJ-1

1. rectangle + incomplete circle design micro-dimensional shading

Create a new blank slide. Use the “rectangle” in the self-selected graphics, draw a square, fill color set to white, no border; copy this square, paste, paste the square fill color set to gray. Arrange the two squares side by side next to each other with the top aligned; select all of the two squares, copy, paste, arrange the two groups of squares side by side next to each other with the top aligned, and so on until the arranged squares are larger than the edge of the slide. Copy the entire row of squares, paste, and align the entire row of copied squares with the previous row in a staggered manner. Draw a three-quarter circle using the “Irregular circle” in the optional graphics, and adjust it to a quarter circle by adjusting the yellow handle of this irregular circle, setting its fill to “Gradient fill”, type ” linear”, angle 45 degrees, the first gradient aperture color selection “white, background 1, dark 15%”, position 50%, transparency 50%, brightness -15%; the second gradient aperture color selection “white, background 1, dark 50% “, position 100%, transparency 50%, brightness -50%; copy this irregular circle, flip it horizontally, and adjust the position of its first gradient aperture to 0%. Arrange these two irregular circles next to each other with the top aligned, drag and drop them to the junction above the two white and gray squares, and so on. This completes the micro-dimensional shading design (Figure 2).

1821A-CLBJ-2

Finally, copy all the graphics, paste them, align them, and then use the self-selected graphics to add other elements and text as needed. In this way, a unique slide background design is complete.

2. use the circle + rectangle design light shadows

Create a new blank slide, set its background color to “white, background 1, dark 5%”. The use of self-selected graphics in the “ellipse”, draw a positive circle, set to no border, fill color “gradient fill”, type “linear”, angle 135 degrees; the first gradient aperture color choose “dark red”, position 0%, transparency 80%; the second gradient aperture color choose “dark red”, position 50%, transparency 20%; the third gradient aperture color choose “dark red “, position 100%, transparency 0%. Draw another rectangle, rotate it by a certain angle, set it as borderless, fill color is “Gradient Fill”, type is “Linear”, angle is 0 degrees; choose “White, Background 1, Dark 25%” for the first gradient aperture color. “, position 0%, transparency 0%; the second gradient aperture color choose “white, background 1, dark 15%”, position 35%, transparency 50%; the third gradient aperture color choose “white, background 1 “, position 100%, transparency 0%; soften the edges, the value of 7 pounds. Overlay the square circle with the rectangle and place the square circle on the top layer so that the rectangle acts as a light shadow for the square circle (Figure 3).

1821A-CLBJ-3

Copy the two shapes, paste them, change the size of the pasted square circle, and also adjust the width of the pasted rectangle to fit the square circle, copy and paste as needed and so on, and change the gradient color of the square circle as needed.

In this way, with a sense of three-dimensional slide background design is complete.

Shaped charts cleverly produced

Use charts to express data, to make people refreshing, some design of the chart is essential. Next, we will look at how to use the construction of optional charts plus charts to create folded charts (Figure 4).

1821A-YXTB-4

1. Construct the data source and insert the chart

First, the data source for the transformation, add two auxiliary columns, two examples of the value of 20, 6. Select all the data, select the “Insert” tab, click “Bar Chart → Stacked Bar Chart”, insert a chart, delete the legend and grid lines. Right-click the chart, select “Select Data Source”, in the pop-up window on the left side of the “Legend Item”, select “Sales”, click the down arrow to move it to the bottom (Figure 5).

1821A-YXTB-5

Right-click on a series in the chart, select “Set Data Series Format”, and in the “Series Options” tab, set the gap width to 20%; right-click on the vertical axis, select “Set Axis Format Right-click the vertical axis, select “Set Axis Format”, and in the “Axis Options” tab, check the “Inverse Order Category” (Figure 6). 2.

1821A-YXTB-6

2. Draw decorative self-selected graphics

Draw a height of 1.5, the color of the rectangle without fill (in order for everyone to see, I set the color to gray); and then draw a height of 0.9 rectangle, the color is red, no lines, right-click it, select “Edit Vertex”, right-click on the left box, select “Add Vertex “Drag this vertex horizontally to the right to the right position. Select the two graphics, select the “Format” tab, click “Align → Bottom Alignment, Horizontal Center Alignment”, and then combined to form a combination of graphics 1 (Figure 7).

1821A-YXTB-7

Draw a rectangle, height 1.5, width 0.8, color red, no lines; and then draw a right triangle, height 0.4, width 0.8, color dark red, no lines. Select these two shapes, bottom alignment, horizontal center alignment, for combination. Draw another rectangle, height 1.1 (rectangle height minus triangle height), width 0.8, color between the rectangle and triangle, the combination of graphics and this rectangle top alignment, horizontal center alignment, forming a combination of graphics 2 (Figure 8).

1821A-YXTB-8

Then draw a height of 1.5, the color of the rectangle without fill; and then draw a height of 1.1 rectangle, width 6, color and the height of 1.1 rectangle in the above figure, the same color, no lines. Select these two graphics top alignment, horizontal center alignment, forming a combination of graphics 3 (Figure 9).

1821A-YXTB-9

Tip: The height, width and color involved in the above operation can be changed as needed. 3.

3. Change the chart style

Select graph 1, copy, select the series representing “Auxiliary column 1” in the graph, and paste; select graph 2, copy, select the series representing “Auxiliary column 2” in the graph, and paste; select graph 3, copy, select the series representing Select Graph 3, copy, select the series representing “Sales” in the chart, and paste. Thus, the preliminary collapsed chart is successfully constructed (Figure 10).

1821A-YXTB-10

4. Add numeric labels

If the data is updated in real time, then the addition of numeric labels requires the use of a scatter chart. Create two more columns of data, column X data for all 2, column Y data for 5.2, 4, 2.8, 1.6, 0.4. Select these two columns of data, copy, select the established chart, click “Selective Paste”, in the pop-up window of “Add cell as “at” select “New Series”, “value (Y) axis at” select “column”, check the “first column in the Category (X label)”, OK, right-click the chart, select “Change Chart Type”, change the corresponding chart type of series 4 to “Scatter Chart”, select the chart series representing X data set to no fill, no No lines. Similarly, then create two columns of data, column X data for column B + C + D data (that is, in cell G2, enter “= B2 + C2 + D2” and fill down), column Y data for 5.5, 4.3, 3.1, 1.9, 0.7, select these two columns, copy, and then select the chart, click “Selective Paste”, in the pop-up window of “Add Cells as”, select “New Series”, “Value (Y) axis in “Select “Column”, check “Category in the first column (X label)”, OK, select the chart series representing X data, right-click them, select “Add Data Label “, right-click the added label, select “Set Data Label Format”, in the label options “Label Include” check the “value in the cell” Select cell B2:B6 (i.e., sales), remove the check box “Y value” and “show guide line”, “label position”, select ” to the left”; select the chart series representing X data set to no fill, no lines (Figure 11).

1821A-YXTB-11

Tip: The values involved in the above operation in column Y can be changed according to the location of the data points in the chart.

6. Modify the chart

After the above operation, the creation of a collapsed chart is basically complete. You can realize the effect that the chart and the position of the labels change as the data changes. Set the colors of Graph 1, Graph 2, and Graph 3 respectively as needed. After setting, copy them separately, then select the corresponding series of products in the chart, and click “Clipboard” at the fill. Finally, select the data labels to change their colors, styles, or add shading effects to the charts. This way, the chart will be more beautiful after retouching.

Leave a Comment