Double-click of one of the " red" series, such as " Red Positive" . When the Format Data Series dialog box appears, select Patterns and set the area color to red. Repeat for the other red series.
You are now ready to begin formatting the chart. Start by hiding the " Blank Positive" and " Blank Negative" columns. Double-click on one of the two blank series to get the Format Data Series dialog box.
Double-click on the x-axis. The Format Axis dialog box will appear. Set the major and minor tick mark types to " None" and the tick mark labels to " Low" . Select Alignment and set the alignment to 90. Select OK.
双击 x 轴。将现“轴格式”对话框。将主要和次要刻度线类型“无”,并将刻度线标签“低”。选择“对齐”并将对齐 90。选择“确定”。