Step 4. Define the X or Y-axis Format

  1. Expand Format.

  2. Choose the Type of format in which the data will be reported.

Type

Does the following:

apNumberInteger

Displays a number as an integer. If the actual number is fractional, it will be rounded.

apNumberFixed

Displays a fixed real number with a specified number of decimal places.

apNumberScientific

Displays a number in scientific notation with a specified number of decimal places. The default is 6 if precision is not specified.

apNumberCompact

Defines an automatic way to use either apNumberFixed or apNumberScientific formats based on the size of the value. Precision information indicates the exponent to start displaying in scientific format.

apNumberAbsoluteTime

Interprets a number as the number of seconds since 00:00 GMT on January 1, 1970.

apNumberAbsoluteTimeEx

Interprets a date and time from the value of the 8-byte floating-point number. Days are represented by whole number increments starting with 30 December 1899 GMT. Hour values are expressed as the absolute value of the fractional part of the number starting at midnight with a value of 0. This is equivalent to the Date type in CimView scripting or Visual Basic.

apNumberRelativeTime

Interprets a number as an elapsed time value in seconds.

apNumberCustom

Uses a format string in the standard C language format notation to display a number.

  1. Make additional entries, when they apply, to more precisely define the selected Type.

  1. For apNumberAbsoluteTime, select the item, Absolute Time. Specify the time format string. Choose your specific entries from the following list. The letters must be in uppercase or lowercase as shown (for example, "ss", not "SS"). Characters in the format string that are enclosed in single quotation marks will appear in the same location and unchanged in the output string.

Entry

Displays

d

Day of month as digits with no leading zero for single-digit days.

dd

Day of month as digits with leading zero for single-digit days.

ddd

Day of week as a three-letter abbreviation.

dddd

Day of week as its full name.

M

Month as digits with no leading zero for single-digit months.

MM

Month as digits with leading zero for single-digit months.

MMM

Month as a three-letter abbreviation.

MMMM

Month as its full name.

y

Year as last two digits, but with no leading zero for years less than 10.

yy

Year as last two digits, but with leading zero for years less than 10.

yyyy

Year represented by full four digits.

h

Hours with no leading zero for single-digit hours (12-hour clock).

hh

Hours with leading zero for single-digit hours (12-hour clock).

H

Hours with no leading zero for single-digit hours (24-hour clock).

HH

Hours with leading zero for single-digit hours (24-hour clock).

m

Minutes with no leading zero for single-digit minutes.

mm

Minutes with leading zero for single-digit minutes.

s

Seconds with no leading zero for single-digit seconds.

ss

Seconds with leading zero for single-digit seconds.

t

One character time marker string, such as A or P.

tt

Multicharacter time marker string, such as AM or PM.

Example

To display 01/01/1999 12:05:00 AM

Use the format string: MM/dd/yyyy hh:mm:ss tt.

  1. For apNumberAbsoluteTimeEx, the format argument consists of one or more of the following format codes. The formatting codes are preceded by a percent sign %. Characters that do not begin with % are displayed unchanged.

Format Code

Description

%a

Abbreviated weekday name

%A

Full weekday name

%b

Abbreviated month name

%B

Full month name

%c

Date and time representation appropriate for locale

%d

Day of month as decimal number (01 - 31)

%H

Hour in 24-hour format (00 - 23)

%I

Hour in 12-hour format (01 - 12)

%j

Day of year as decimal number (001 - 366)

%m

Month as decimal number (01 - 12)

%M

Minute as decimal number (00 - 59)

%p

Current locale's A.M./P.M. indicator for 12-hour clock

%S

Second as decimal number (00 - 59)

%U

Week of year as decimal number, with Sunday as first day of week (00 - 53)

%w

Weekday as decimal number (0 - 6; Sunday is 0)

%W

Week of year as decimal number, with Monday as first day of week (00 - 53)

%x

Date representation for current locale

%X

Time representation for current locale

%y

Year without century, as decimal number (00 - 99)

%Y

Year with century, as decimal number

%z, %Z

Time-zone name or abbreviation; no characters if time zone is unknown

%%

Percent sign

The # flag may prefix any formatting code. In that case, the meaning of the format code is changed as follows:

Format Code

Description

%#a, %#A, %#b, %#B, %#p, %#X, %#z, %#Z, %#% #

 

Flag is ignored. (Format code above)

%#c

Long date and time representation, appropriate for current locale. For example: "Tuesday, March 14, 1995, 12:41:29".

%#x

Long date representation, appropriate to current locale. For example: "Tuesday, March 14, 1995".

%#d, %#H, %#I, %#j, %#m, %#M, %#S, %#U, %#w, %#W, %#y, #Y

 

Remove leading zeros (if any). (Format code above)

  1. For apNumberCustom, select the item Custom. Use a format string in the standard C language format notation to display a number.

  2. For apNumberScientific or apNumbercompact, select Precision if you need to change it from the default of 6.

  3. For apNumberRelativeTime, select RelativeTime. Choose one entry :

Entry

Displays relative time as:

apTimeDDHHMMSS

Day:hours:minutes:seconds

apTimeHHMMSS

Hours:minutes:seconds.

apTimeHHTenths

Hours and tenths

apTimeMMSS

Minutes:seconds.

apTimeMMTenths

Minutes and tenths

More information

Design XY Plot axes.