Formatting numbers, dates, and times
You can format numbers, dates, or times that the chart displays in a variety of ways. Format numbers and produce multiples of them in the following ways:
Add a prefix, such as a currency symbol.
Multiply values by a number, such as 100.
Add a suffix to a number value, such as the word million.
Determine the number of decimal places that numbers include.
Specify a number format pattern, such as #.###, which formats numbers using a point as the thousands separator.
Format the following attributes of dates and times:
Type. Use a standard format, including Long, Short, Medium, and Full.
Details. Specify that the format is Date or Date Time.
Pattern. Specify a pattern, such as MMMM to show only the month value or dddd to show only the day value, such as Wednesday.