Two instances of using Excel to clone an information chart

two instances of using Excel to clone an information chart

The so-called information graph imitation, is to use the limited function of Excel, as far as possible to achieve the appearance of some information charts, so that the advantages of the two perfect combination.

The implementation methods are as follows:

Use Excel to clone an information chart instance one

This information graph is a triangular jagged chart that is opposite the x-axis along the x axis, and we can use a column chart to simulate the simulation.

Step 1:

First, the preparation of the data. On the basis of the original two-column data, you need to add a list of secondary data, because the chart is the reverse of the x axis of the two sets of triangular graphics, you need a set of data to use negative numbers plotted in the negative coordinate area. In this example, you can take the negative number of the second series "IOS" data, and then subtract 500 to get the secondary column data. The purpose of subtracting 500 is to generate a reverse graphic that can be used to display the category label with a certain distance from the x-axis.

Step 2:

Generate a clustered Column chart with the first data series "Android" and the newly generated "secondary" data column, "Android" data is displayed above the x-axis of the chart, and "secondary" data is displayed below the x-axis.

Step 3:

Select the secondary data series (the data series located below the x-axis), right-click to set the series format, and set this data series on the secondary axis.

Step 4:

Double-click the left vertical axis to set the maximum value to 2000 (slightly larger than the maximum value in the actual data), and set the minimum to the negative number of the maximum that you just had, that is, 2000. Double-click the vertical axis on the right, the same number set the maximum and minimum value, in addition to the need to set "cross axis" to "500", that is, step 1 in the auxiliary column used in this parameter. This allows the column of the auxiliary series to be drawn from-500, while the 0~-500 interval does not display a column shape. By doing so, the actual column length of the "helper" series matches the original "IOS" data.