Shulou(Shulou.com)11/24 Report--

Hi, I am the uncle Mr Zhao who prefers function formulas and likes to use Excel charts to manage warehouses.

When we make charts, bar charts are the most commonly used type of chart. No doubt, it is very important.

But how to make the chart pleasing to the eye is the pursuit of chart controllers. Even a few small embellishments can bump into a different kind of beauty.

For example, under the same conditions, it can also be vivid and interesting to show the bar chart as a folding effect:

Perhaps most people's first reaction to the picture above is to do it with PPT. However, it is decorated with "makeup" with Excel throughout the process.

Then some friends will question it:

But compared with PPT, drawing with Excel, the chart will change as the data is updated, and you don't have to change it manually over and over again.

Let's talk about how to make such a beautiful chart with Excel.

Drawing idea: the idea of this kind of bar chart with folding effect is to copy and fill the drawn graph into the stacked bar chart.

The steps are as follows:

Data preparation

In order to reflect the random dynamics of the data, enter the random function RAND in the C column and change the cell format to "percentage".

Then add a secondary column and enter a value of 0.1 in column D, as shown in the following figure:

Insert stacked bar chart

❶ select any cell in the data region-open the insert tab-locate the bar chart and click-Select Stack Bar Chart.

❷ Select Chart-[right]-[Select data]-Select [Auxiliary] Series-adjust to the top of the [proportion] series.

❸, select * * Category Axis * *-> * * right * *-> * * format axes * *-check * * reverse categories * *.

Draw a graph

Select the [insert] tab-[shape]-insert the [rectangle] and [right triangle] shown below, respectively.

❶ splices [combines] a rectangle and a right triangle rotated 180 degrees to form a set of graphics, as shown in the following figure:

❷ uses two rectangles to splice [combine] into a group of graphics, one of which is set to colorless, as shown in the following figure:

Copy and paste graphics to chart

❶ respectively select the combined graphics-press the shortcut key [CTRL+C] to copy-then select the series in the chart-press the shortcut key [CTRL+V] to paste.

Ps: if, in the course of operation, you find that the two groups of graphics are connected in a dislocation in the chart, fine-tune the width of the graph, and then copy and paste it into the chart.

❷ adjusts the width of the bar chart. Click any series-[right]-[format data Series]-[Gap width] to adjust to 10%.

Beautify the chart

❶ deletes gridlines, legends, and numerical axes, sets the chart area format color to no fill, and sets the classification axis lines to colorless. The effect is as follows:

❷ inserts a straight line and [at the bottom], and then selects the chart [combination].

❸ adds chart tags and sets font colors, as shown in the following figure.

Write at the end

Learn the method of making a watch, but also learn the idea of making a watch. The styles of charts in Excel are never fixed, and we need to think twice about when to choose which charts to use.

In this paper, the folding bar chart is combined by self-made graphics, and then filled into each series of stacked bar charts, which is suitable to show and compare the size of different categories of data.

Using this method, you can certainly make charts of other folding effects.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Zhao Jiaoyang, Editor: Zhu Lan

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.