Specifying other settings for charts

Otherwise, the sum is not displayed.

This means that each column displays as a 100% total, with each stack segment represented as a percent of the total.

Otherwise, the chart displays as a normal stacked chart with columns of varying heights.

Anything beyond this width is truncated.

Otherwise, this name displays at the top.

Otherwise, anchors are hidden.

This depends on how you want the anchors to display. For example, a setting of “3” here causes anchors to display as triangles, “4” as squares, and so on.

Valid values range from 3 to 20.

If this value is not specified, anchors render as circles.

The greater this number is, the larger the anchor displays.

You can double-click to display the “Color” dialog box, where you can select a color or define a custom color for the anchor border. The hexadecimal code displays after you click “OK” to exit the “Color” dialog box.

You can double-click to display the “Color” dialog box, where you can select a color or define a custom background color for the anchor. The hexadecimal code displays after you click “OK” to exit the “Color” dialog box.

To use a gradient background fill, specify multiple hexadecimal values, separated by commas.

Otherwise, numbers are displayed without separators.

Otherwise, numbers are not truncated and rounded.

Otherwise, all numbers display with only the number of decimal places required.

Otherwise, Y-axis numbers display with only the number of decimal places required.

For example, if the numbers to be formatted represent the number of seconds in a time sequence, then you would specify “seconds” in this field.

For example, to change the way numbers are displayed based on their values, you can specify a Thousands to Millions to Billions conversion sequence. To do this, you would specify “K, M, B” in this field.

To make time conversions (minutes to hours to days to weeks, for example), you would specify “Min, Hr, Day, Wk” in this field.

This specification must be used in conjunction with the “Number Scale Value” specification.

For example, to convert from thousands to millions to billions, you would specify “1000, 1000, 1000” in this field. To convert from the default of seconds to minutes to hours to days to weeks, you specify “60, 60, 24, 7” in this field.

This specification must be used in conjunction with the “Number Scale Unit” specification.

For example, if all numbers represent money amounts in dollars, you would specify the dollar sign (“$”) in this field.

For example, if all numbers represent an amount produced in a year's time, you would specify “per year” or “/yr” in this field.

For example, in some countries, a period (which is the system default) is used to separate whole numbers from decimal parts. In other countries, a comma is used for this purpose. In this latter case, you would specify a comma (“,”) in this field.

For example, in some countries, a comma (which is the system default) is used to separate whole numbers with more than three digits with commas every three digits. In other countries, a period is used for this purpose. In this latter case, you would specify a period (“.”) in this field.

For example, if you were to specify “2,3” in this field, a number with nine digits would be formatted with a comma between the second and third digit from the right, and every third digit after that. If the number to be formatted were 123456789, it would be formatted as 1,234,567,89.

You can double-click to display the “Color” dialog box, where you can select a color or define a custom color for the divisional lines. The hexadecimal code displays after you click “OK” to exit the “Color” dialog box.

You can double-click to display the “Color” dialog box, where you can select a color or define a custom color for the zero plane. The hexadecimal code displays after you click “OK” to exit the “Color” dialog box.

Otherwise, only divisional lines display, with no colored bands between them.

You can double-click to display the “Color” dialog box, where you can select a color or define a custom color for the horizontal bands. The hexadecimal code displays after you click “OK” to exit the “Color” dialog box.

Otherwise, only divisional lines display, with no colored bands between them.

You can double-click to display the “Color” dialog box, where you can select a color or define a custom color for the vertical bands. The hexadecimal code displays after you click “OK” to exit the “Color” dialog box.