Chart Background

1) The chart background is a setting under the Chart Style attribute, through which the display layout and style of the chart background can be changed.

2) The area covered by the chart background includes the chart area and the drawing area. The chart area includes the area occupied by the whole chart, and the drawing area only includes the area within the coordinate axis. As shown below, 1 represents the chart area, and 2 represents the drawing area.

3) This document describes general background settings. For charts with special background settings, please refer to their own document for specific descriptions.

4) Suggested reading: Chart Data, Chart Types.

Please refer to Section II Insert a Simple Chart of Chart Series. Those already familiar with inserting charts may skip this section.

Take floating chart-column chart as an example.

Double-click the chart, and select [Style] > [Background] > [Chart Area] on the right to perform chart area background adjustment. You can see that the background of the chart area contains two settings: border and background. Adjustments made to the style can be seen in real time in the floating chart effect on the left. As shown in the following diagram:

1. Border of chart area

Here you can set the border style of chart area.

• Line type: four border line types can be set: none, thin, medium and thick.

• Color: Set the color of the border

• Rounded corners: you can set the rounded corners of the four corners of the border. By default, the added borders have no rounded corners

Here, we set the line type to [Medium], the border color to [Light Red], and the rounded corners to [15]. The effect is as follows:

Note:

• If the chart is a cell chart, it is necessary to clear the indentation of the cell when setting the chart border, otherwise the border cannot be fully displayed. You need to set the indentation to 0 in [Cell Attributes] > [Style] > [Alignment] > [Advanced].

• When the title, legend and alert line of the chart overlap with the border of the chart area, the border of the chart area is displayed on the lower layer. When the label, graph, axis and data table of the chart overlap with the border of the chart area, the border of the chart area is displayed on the upper layer.

2. Background of chart area

Here you can set background fill, opacity and shadow for the chart area.

• Fill contains four settings: no background, color, image and gradient color.

• Opacity: the opacity percentage of background can be set from 0 to 100.

• Shadow: Set whether or not to enable the shadow effect and it is Off by default.

For example, add a light red background color to the chart, set the opacity to 20%, and enable the shadow effect.

Take floating chart-column chart as an example.

Double-click the chart, and select [Style] > [Background] > [Drawing Area] on the right to perform drawing area background adjustment. There are five types of drawing area style settings: border, background, grid line, alert line and interval background. Adjustments made to the style can be seen in real time in the floating chart effect on the left. As shown in the following diagram:

The settings of the border and background of the drawing area are the same as those of the chart area, so they will not be repeated here.

1. Grid line

You can set the grid effect of the chart drawing area here.

• Horizontal: The line type can be solid or dashed, and the line color can be custom

• Vertical: The line type can be solid or dashed, and the line color can be custom

We can set solid gray lines for the horizontal and dashed gray lines for the vertical.

2. Alert line

Here, you can set an alert line as a reference standard or define a target value.

Click [+] to add an alert line.

1) Setting of alert line:

• Location: X-axis or Y-axis alert line can be set

• Value: the value of alert line, which can be filled in the formula

• Line type: Can be set to solid line or dotted line

• Color: Set the line color

For example, we set the Y-axis alert line, the value is 2000, and keep the line type and color as default.

2) Setting of prompt text:

• Location: set whether the prompt text is displayed on the left or right side of the alert line

• Content: the content can be entered by formula

• Font: Select the font

• Size: the size of the font used

• Color: the color of the font used

For example, we set the prompt text to be on the right, the content is [Cost Alert], the font and size are kept by default, and the color is selected as red.

The preview effect is as follows:

3. Interval background

We can add the interval background to the drawing area according to the grid lines of the horizontal and vertical axes.

• Interval background: you can choose [Default] or [Custom]

• Default: horizontal color takes precedence. For example, the background of horizontal interval is light yellow, and the background of vertical interval is light orange.

• Custom: If you need to set the background separately for each interval, you can choose to set by customizing the interval background

For example, if you want to vertically divide it into three areas, each with a different color. Click [+] to add three custom intervals.

Make the following settings respectively:

The first interval is the section from 0 to 2000 on the Y-axis, and the background is set to be yellow and opaque.

The second interval is the section of 2000-6000 on the Y-axis, and the background is set to be light green and opaque.

The third interval is the section of 6000-10000 on the Y-axis, and the background is set to be light blue and opaque.

The preview effect is as follows: