Current location - Quotes Website - Personality signature - How to set the abscissa axis label of EXCEL column chart
How to set the abscissa axis label of EXCEL column chart
Prepare data and add corresponding auxiliary columns to the original table data, as shown in Figure C: D..

Select two columns of data, A and B, to create a column chart table, then choose to copy two columns of data, C and D, click the chart and paste the data directly. At this point, the chart style is as follows.

In order to select a column chart with columns C and D in the chart, you can temporarily set the value of D2 to a larger value so that the column chart can be displayed. Click the column corresponding to the auxiliary column to change its chart type to: line chart with data label. At this point, the chart style is as follows.

Right-click the auxiliary column, select: Add data label, right-click the data label, and select: Format data label to make the setting changes shown in the dialog box. At this point, the chart style is shown in Figure 2.

Right-click the auxiliary column chart and select: Set data series format, as shown in figure 1. At this point, the chart style is shown in Figure 2.

Right-click the label of the horizontal axis and select: Set the format of the axis, as shown in figure 1. Other settings can be set by default. At this point, the chart style is shown in Figure 2.

Finally, don't forget to change the original D2 cell value to 0 to further beautify the chart.