Editing chart properties

The Chart Properties dialog box is where you select different settings for displaying the chart. You can change the colors for bars, columns, lines, or points in the chart. The chart title and the various values to be displayed on the chart can also be formatted. You can also configure the chart to be drawn as a 3D image.

1.	In the Chart window, click the Chart Properties icon. The Chart Properties dialog box appears.

Figure 236 

Options on the Appearance tab

2.	On the Appearance tab, you can edit the fields and settings listed in the following table.

Table 24 

The fields and settings on the Appearance tab

Field/Setting	Description
Width	Specify the width in pixels of the chart.
Height	Specify the height in pixels of the chart.
Color (Chart Area)	Click the button beside this field to select a color for the chart background.
Plot Area Color	Click the button beside this field to select a color for the grid area background. This color displays only in the area reserved for drawing the chart.
Color (Series)	In the Series section, click the button beside this field and select a color for the bars, columns, lines, or points.
Enable Border	Select this check box if you want the bars, columns, lines or points of the chart to be drawn with a border.
Border Color	Click the button beside this field and select a color for the border for the bars, columns, lines, or points.
Border Width	Select the point size for the border.
Text	Enter the title of the chart in this field.
Font	Select a font from this list. The chart title is displayed in this font.
Size	Select the font size for the chart title from this list.
Style	Select the font style for the chart title from this list.
Color (Chart Title)	Click the button beside this field and select the font color for the chart title.
Alignment	Select the position from this list where you want the chart title to be displayed.
Underline	Select this option to underline the chart title.

3.	Click the X-Axis tab for options for the x-axis.

Figure 237 

Options on the X-Axis tab

The X-Axis settings are defined in the following table:

Table 25 

The fields and settings on the X-Axis tab

Field/Setting	Description
Display (Axis Lines)	Select this check box so that the axis is drawn on the chart.
Width	Select the width of the axis from the list.
Color	Click the button beside this field and select the color for the axis lines on the chart.
Show Gridlines	Select this check box so that the chart grid is displayed.
Reverse position	Select this check box if you want to reverse the placement of the axis on the chart.
Display (Axis Labels)	Select this check box if you want to display the axis labels on the chart.
Font (Axis Labels)	Select the font type from the list for the axis labels on the chart.
Size (Axis Labels)	Select the font size from the list for the axis labels.
Style (Axis Labels)	Select the font style from the list for the axis labels.
Color (Axis Labels)	Click the button beside this field and select the color for the axis labels on the chart.
Text (Axis Title)	Specify the text for the title of the axis in this field.
Font (Axis Title)	Select the font type from the list for the axis title.
Size (Axis Title)	Select the font size from the list for the axis title.
Style (Axis Title)	Select the font style from the list for the axis title.
Color (Axis Title)	Click the button beside this field and select the font color for the axis title.

4.	Click the Y-Axis tab to select settings for the y-axis on the chart. The Y-Axis tab has the same fields and options as the X-Axis tab.

5.	Click the Other Options tab to set any remaining options for the chart.

Figure 238 

The Other Options tab

6.	Select settings as described in the following table.

Table 26 

Fields and settings on the Other Options tab

Field/Setting	Description
Enable	Select this check box to display the chart as a 3-D image.
Perspective	Specify the percentage of perspective for the 3-D chart. This value must be in the range of 0 to 100.
Horizontal	Specify the angle by which the chart will rotate horizontally. This value must be in the range of -180 to 180 degrees.
Vertical	Specify the angle by which the chart must rotate vertically. This value must be in the range of -180 to 180 degrees.
Display legend on chart	Select this check box to display the legend on the chart.
Docking	Select the area of the chart where the legend will display.
Alignment	Select the vertical position where the legend will display.
Display labels on chart	Select this check box to display the y-axis values on the plot area of the chart. If this check box is not selected and the y-axis is configured to be displayed on the chart, the y-axis labels are displayed next to the axis only.
Label	Use the Visual Basic expressions below to display Y or X axis values on the chart in commonly used numeric formats. Y values For integers, enter #VALY{d} For float values, enter #VALY{Fn}, where n indicates the number of decimal places. • For example, for values such as 23.434, indicate the expression #VALY{3} For currency values with two decimal places, indicate #VALY{F2} For scientific notation whose result contains two decimal places, indicate #VALY{E2}. • For example, for values such as 2.314524E+001, indicate the expression #VALY{2} For fixed point values, indicate #VALY{F2}. • For example, for values in the same format as 23.43, indicate the expression #VALY{2} For percentages with two decimal places, indicate the expression #VALY{P2} • For example, for values in the same format as 2314.52%, indicate the expression #VALY{P2} X values To display the x values on the chart, enter #AXISLABEL
Font	Select a font from the list for the y-axis values.
Size	Select a font size from the list for the y-axis values.
Style	Select a font style from the list for the y-axis values.
Color	Click the button beside this field to select a background color against which the y-axis values are to be displayed.
Display tooltip on chart	Select this check box to display a tooltip when you move the mouse over the chart data.
Label	Enter whatever text you want to display in the tooltip or use the Visual Basic expressions below to display Y or X axis values on the chart in commonly used numeric formats. Y values For integers, enter #VALY{d} For float values, enter #VALY{Fn}, where n indicates the number of decimal places. • For example, for values such as 23.434, indicate the expression #VALY{3} For currency values with two decimal places, indicate #VALY{F2} For scientific notation whose result contains two decimal places, indicate #VALY{E2}. • For example, for values such as 2.314524E+001, indicate the expression #VALY{2} For fixed point values, indicate #VALY{F2}. • For example, for values in the same format as 23.43, indicate the expression #VALY{2} For percentages with two decimal places, indicate the expression #VALY{P2} • For example, for values in the same format as 2314.52%, indicate the expression #VALY{P2} X values To display the x values on the chart, enter #AXISLABEL

7.	When finished, click OK and click the appropriate chart icon to view the chart.