Shortcut:
![]() | Right-click on numbers along any axis to select the number format for that axis. |
Displays a dialog box that allows you to specify the appearance of numbers on the axes of the plot.
The following table shows some examples using the available number formats.
With this format |
This number |
Is displayed as |
|
Default |
-1.5 |
-1.5 |
|
|
0. |
0. |
|
|
1.5 |
1.5 |
|
None |
any |
nothing |
|
Scientific |
-1.5 |
-1.5E+0 |
|
|
0. |
0E+0 |
|
|
1.5 |
1.5E+0 |
|
Powers of 10 |
150 |
||
|
0 |
0 |
|
|
0.015 |
||
Engineering |
|
identical to Powers of 10, but all exponents are multiples of 3 |
|
Percent |
|
150% |
|
Currency 1 |
-1.5 |
($1.50) |
|
see below |
0. |
$0.00 |
|
|
1.5 |
$1.50 |
|
Currency 2 |
-1.5 |
($2) |
|
see below |
0. |
$0 |
|
|
1.5 |
$2 |
|
Time of day (hours) |
1 |
*01:00:00 AM |
|
|
1.5 |
*01:30:00 AM |
|
|
13 |
*01:00:00 PM |
|
Time of day (fractional days) |
0.04166667 (1/24) |
*01:00:00 AM |
|
|
0.25 |
*06:00:00 AM |
|
|
0.5 |
*12:00:00 PM |
|
Calendar date |
1 |
*1/1/1900 |
|
|
35242 |
*6/26/1996 |
|
Date and Time |
35242 |
*6/26/1996 12:00:00 AM |
|
|
35242. 5210069 |
*6/26/1996 12:30:15 PM |
|
Day of the Week |
1 |
Sun |
|
|
2 |
Mon |
|
|
8 |
Sun |
|
Month |
1 |
Jan |
|
|
12 |
Dec |
|
Elapsed time |
-1.5 |
-1:30:00 |
|
|
0 |
0 |
|
|
1.5 |
1:30:00 |
|
Fractions |
0.4 |
||
|
1.5 |
||
Fractions, no reduction |
0.4 |
||
Pi Multiples |
0.785398 |
0.25π |
|
|
4.71239 |
1.5π |
|
Pi Fractions |
0.785398 |
π/4 |
|
|
4.71239 |
3π/2 |
|
Degrees, Minutes |
35.505556 |
35° 30.3' |
|
Degrees, Minutes, Seconds |
35.505556 |
35° 30' 20" |
|
Hexadecimal |
5346.24 |
0x14E2 |
* dependent on Date Format and/or Time Format settings
Axis
The X2 and Y2 axis entries (XY plots only) correspond to the secondary axes established by the Multiple Axes menu command. These selections are disabled if the corresponding axis has not been enabled. The Orientation settings are disabled for these entries and are forced to the orientation setting for the corresponding primary axis.
Format
Default format
Numbers with absolute values smaller than 0.00001 or larger than or equal to 10,000,000 are displayed in scientific notation with up to 5 significant figures. Trailing zeros are not displayed.
None
This format is primarily useful for creating blank graph paper. See the How do I? topic for more information.
Fractions
DPlot will pick the denominator from 2,3,4,5,6,8,10,12,15,16,20,24,25,30,32,40,50,60,64 that gives the smallest error. Fractions smaller than 1/128 are truncated. The Fraction format will reduce the fraction to its lowest terms, e.g. 3/60 becomes 1/20. Fractions, no reduction is identical other than that reduction: if the tick mark interval on an axis is 1/60 and a tick mark is at 3/60, it will be displayed as 3/60 rather than 1/20.
Currency
DPlot uses the currency format set with Control Panel's Regional Settings applet.
Time of day
For "Time of day (hours)", amplitudes should be in hours. Note that this differs from "Date and Time" and "Time of day (fractional days)" formats, in which time values are fractions of days. The time scale wraps around every 24 hours, with 0.0 equal to midnight (-1.0 = 23.0 = 47.0 = 11:00 PM, etc.) By default, DPlot uses the time format set with Control Panel’s International (or Regional Settings) applet. You can control how the time is formatted by entering a format string in the Time Format box.
Time format notation:
h = hour, m=minute, s=second, t=AM or PM (ignored for 24 hour clock)
h = 12 hour clock, H = 24 hour clock
hh or HH = leading zero on hour
h or H = no leading zero on hour
A ‘.0’ suffix will add tenths of seconds, ‘.00’ will add hundredths of seconds, etc. You can display time increments as small as microseconds with '.000000'. A seventh or subsequent 0 will be displayed but is ignored for formatting purposes.
Calendar date
DPlot converts the input Excel serial number to a calendar date. By default, DPlot uses the Short Date format specified in Control Panel’s International (or Regional Settings) applet for formatting the date. You can control how the date is formatted by entering a format string in the Date Format box. Use the letters in the following table to change the date style. As you type, the current date formatted using this style is shown below the style box.
To display |
Use |
Numbers with no leading zeros for single-digit days, years, or months. |
Lowercase d or y, or uppercase M |
Numbers with leading zeros for single-digit days, years, or months. |
Lowercase dd or yy, or uppercase MM |
Three-letter abbreviations for the day of the week or month. |
Lowercase ddd or uppercase MMM |
The full name of the day of the week, year, or month |
Lowercase dddd or yyyy, or uppercase MMMM |
The day of the year (Jan 1=1, Dec 31=365 or 366) |
Lowercase n |
Date and Time
Identical to Calendar date, with the exception that Calendar Date will sometimes include the time depending on the spacing between data values and the context, while Date and Time will always show the time in addition to the date, dependent on the Time format string. If you want to show only the time using this format, use <none> for the date format string.
Hexadecimal
Displays numbers in signed hexadecimal notation, dependent on the Size and Prefix settings under Hexadecimal Parameters. Fractional values are truncated. Numbers outside the range -0x80000000 to 0x7FFFFFFF (-2,147,483,648 to 2,147,483,647) are displayed using the default numerical format. The Size parameter will be ignored for amplitudes greater than the maximum value for that size. For example, if you select 1 Byte and a value is outside the range -128 to 127, 2 Byte will be forced on.
Degrees, Minutes and Degrees, Minutes, Seconds
The Use N/S/E/W suffix setting is only applicable to these formats. This setting is only used for numbers displayed along the X or Y coordinate axes for linear scales or Mercator projections. (It is not used, for example, in dialog boxes, the status bar, popup windows displaying coordinate values, or any other scale type.) If checked, the absolute values will be displayed along with the appropriate suffix (N or E for positive values, S or W for negative values).
Use 1000 Separator (,)
Check this box to display the thousand's separator character before every 3rd digit in the whole number portion of a value. The separator character is set by Control Panel's Regional Settings applet.
Decimal places
If Fixed number is checked, then the corresponding number of figures (including trailing 0's) are displayed after the decimal point. This option is only used for the default number format and for percentages, and is ignored for absolute values less than 0.00001 or larger than or equal to 10,000,000. Please note that this option does not enforce settings that make sense: 0.0001 will be displayed as 0.000 if 3 digits are selected, for example.
Orientation
Allows you to control the orientation of the numbers along each axis (default is horizontal). This option is ignored for polar plots, triangle plots, and 3D plots, and for secondary axes on XY plots is forced to the setting for the corresponding primary axis.
Note: Most moderate-sized non-bold fonts will have a pronounced aliasing problem at orientations other than horizontal or vertical on your display. They're ugly, in other words. The equivalent bold font will generally have a better appearance in this case. This applies mainly to the display and saved bitmaps; printed fonts will generally look good regardless of the orientation or font weight.
|
Related macro commands |
Page url:
https://www.dplot.com/help/index.htm?helpid_numberformats.htm