The Format Scatter dialog box is used to format the scatter of a scatter chart.
Show Category and Series
Specifies whether to include the category and series values in the hint of the data markers.
Auto Scale in Number
Specifies whether to automatically scale the values displayed in the data marker hint that are of the Number data type when the values fall into the two ranges:
- When 1000 <= value < 10^15, the following quantity unit symbols of the International System of Units are used to scale the values: K (10^3), M (10^6), G (10^9), and T (10^12).
- When 0 < value < 0.001 or value >= 10^15, scientific notation is used to scale the values.
By default it is set to auto which means that the setting follows that of the chart platform.
Applies the changes and closes the dialog box.
Does not retain any changes and closes the dialog box.
Displays the help document about this feature.