Axes
Scatter Chart X and Y-axes are numerical axis of values. You can specify various axes settings to change visual data presentation.
To access X and Y-axis settings, use the X-Axis Settings/Y-Axis Settings buttons in the Diagram group on the Design ribbon tab of the Scatter Chart Tools contextual tab set.
This will invoke the X-Axis Settings/Y-Axis Settings dialog, containing the Common and Numeric Format tabs.
In the Common tab you can specify the following settings.
|
Always show zero level
|
Specifies whether the axis' zero level is visible. If this option is unchecked, the visible axis range is defined based on the values plotted in the chart.
|
|
Reverse
|
Allows you to reverse the axis. If the axis is reversed, its values are ordered from top to down.
|
|
Show grid lines
|
Allows you to hide and show grid lines for the axis.
|
|
Show axis
|
Allows you to hide and show the axis.
|
|
Show title
|
Allows you to hide and show the axis title. You can choose whether to use the default text or specify a custom string.
|
|
Logarithmic scale
|
Specifies whether the axis should display its numerical values using a logarithmic scale. The combo box next to this option allows you to select the logarithmic base from one of the predefined values.
|
The Numeric Format tab allows you to specify the numeric display formats for axis data, as described in the Formatting Data document. In code, you can use the ScatterChartAxis.NumericFormat property.
The tab contains the following settings.
|
Format type
|
Specifies format types for numeric values
|
|
Unit
|
Specifies the unit to convert the numeric values.
|
|
Precision
|
Specifies the number of fractional digits to display.
|
|
Currency
|
Specifies the currency symbol and format
|
|
Culture
|
Specifies the name of a culture that defines the currency symbol and format.
|
|
Include group separator
|
Specifies whether separators should be inserted between digit groups.
|