Excel draws a column chart with up and down arrows

Excel draws a column chart with up and down arrows

Basic data and chart effects

First step

Click any cell in the data range and click Insert Clustered Column chart. Inserts a column chart with a default style.

Second Step

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

Third Step

Right-click the Chart data series "Format data series", the series overlaps to-8%, and the category spacing is 90%.

To set the data series fill color:

Fourth Step

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.