Excel makes a two-dimensional column, which requires that when the column is higher than a certain value, the higher part is highlighted in other colors. Ask for advice on how to do it

1, description: "quota" is a specific value, "excess" is a higher part, and its value is equal to sales-quota;

2. Specific operation: First, hold down the CTRL key and select the first, third and fourth rows of the data table in the figure respectively;

Execute the Insert/Chart command, select the chart type as Stacked Column Chart, and press Next;

Set other chart options to complete chart making.