Current location - Loan Platform Complete Network - Big data management - Excel makes a 2D bar chart that requires that when the bar is higher than a formulated value, the higher portion is highlighted in a different color. Seek guidance on how to do
Excel makes a 2D bar chart that requires that when the bar is higher than a formulated value, the higher portion is highlighted in a different color. Seek guidance on how to do

1, Description: "quota" that is, a particular value, "excess" that is, the higher part of the value is equal to the sales - quota;

2, Specific operations: First, hold down the CTRL key and do not let go, respectively, to select the figure in the data sheet the first line, the third line and the fourth line;

The implementation of the "Insert" / "Chart" command, select the chart type "stacked bar chart" and press "Next";

Set other chart options to complete the production of the chart.