文档介绍：任务完成缺口沪东 1248 004 沪北 15 105 00 10 155 沪东完成差距沪北完成差距 1248 15 105 00400 10 0 2 4 6 8 10 12 14 16沪东完成差距沪北完成差距 124 8 15 10 5 0 2 4 6 8 10 12 14 16沪东完成差距沪北完成差距 124 8 15 10 5 差主系列完成任务超主系列完成次系列完成占位任务占位超额次系列东 124 12 #N/A 4 #N/A 南#N/A 16 15 16 #N/A 15 西 969 #N/A 6 #N/A 北#N/A 979 #N/A 7 0 2 4 6 8 10 12 14 16 18东南西北-8 -3 12 2 Expenditure 完成任务差标签超标签-81-32 Select chart data source A1:I4 Use the chart wizard to create a clustered column chart. Added label 'Expenditure' to the Yaxis Format last 4 series so they use the secondary axis. Select - Diff Mask column. Right click and choose Selected Object in order to format it. On the Axes tab select secondary axis. Repeat for Dummy Actual Dummy Budget - Diff Mask Delete secondary Y axis. Remove Grid lines. Format PlotArea Fill to automatic Delete secondary Y axis. Remove Grid lines. Format PlotArea Fill to automatic Now format the bars to give the Diff values the impression of floating. Select column - Diff Mask. Right click and choose selected object in order to format it. Set border to None Set Fill to White ( same colour as Plotarea) Repeat for + Diff Mask Select column - Diff Right click and choose Selected object in order to format it. Set border to None Set Fill to Red Repeat for + Diff, colour Green In order for the Diff bars to display the correct values we need to link the data labels to cells, rather than use real values. Select column - Diff Right click and choose selected object in order to format it. Apply data labels (show values). Do not worry that the #NA are currently showing. In order for the Diff bars to display the correct values we need to link the data labels to cells, rather than use real values. Select column - Diff Right click and choose selected object in order to format it. Apply data labels (show values). Do not worry that the #NA are currently showing. To link the data labels to cells either use an addin, see left of chart for 2 mendations, or do it manually. Select a single data label. Click in the Formula