You can specify display options for lines in line and combo charts. For example, you can display lines in separate rows, stacked as a percentage of the total of all values, or stacked as absolute values.
To format lines in line and combo charts:
On the Chart Properties property sheet, click the Format Chart button.
Select one of the following line types:
To display the line sets in separate rows, select Rows. For example, if you define the 3D depth as nonzero, the lines are displayed in separate rows, from front to back.
To display the line sets stacked on top of each other, normalized to 100%, select Percent. As each line set is drawn, its values are added to previous values displayed and are shown as percentages of the total of all values.
To display the line sets stacked, select Stack. As each line set is drawn, its values are added to previous values. Select one of the following from the drop-down list:
To show the numerical value or data that the line represents, select the Show Point Values check box. The value is displayed on top of the line.
To set font options for the point values of the lines, click the Font button, .
You can define styles for the lines representing the current data set. For more information, see Defining Styles for Data Sets. |