method for Excel to make column chart with up-down arrows

method for Excel to make column chart with up-down arrows

Basic data and chart effects

1th Step: Click any cell in the data area and click "Insert" "Clustered Column Chart". Inserts a column chart with a default style.

2nd step: Click the grid line, and then press the DELETE key to clear. In the same way, remove the chart title, the main vertical axis, and the legend item.

3rd Step: Right-click the Chart data series "Format data series", the series overlap to 8%; The sorting spacing is 90%.

To set the data series fill color:

Step 4th: Add secondary data.

The Y Axis 1 formula is:

=if (C2

The Y Axis 2 formula is:

=if (C2>=b2,c2+1,na ())

Copy y-Axis 1 secondary data, click the chart, press CTRL + V, and the chart adds a column chart data series.

Click the new data series, design, change chart type, and select Scatter chart.

Click the Scatter series in the chart, right-click Select data, eject the Select Data Source dialog box, and click Edit button to add a series name and x-axis series values.

5th step: Copy y Axis 2 secondary data, click the chart, press CTRL + V, the chart will add a scatter chart data series.

Click the new scatter series in the chart and refer to step 4 to add the series name and the x-axis series values.

6th step: Click the secondary horizontal axis, press the DELETE key to clear.

Click the secondary vertical axis and press the DELETE key to clear it.

Right-click the scatter 2 data series format data series. Sets the data marker to a built-in triangle.

Sets the data marker fill to solid fill, and the color selection is green.

Step 7th: Click Insert Shape to select Isosceles.

Flip the triangle and set the color to red.

Step 8th: Click the red inverted triangle and press CTRL + C to copy it.

Click the scatter Chart data series and press CTRL + V to paste.

9th step: Click on the Scatter Plot data series, right key to add data labels.

The secondary column enters the formula used to calculate the percent rise:

= (C2-B2)/b2

Modify the label manually or by using the label tool.

Finally, use two text boxes to add the year.