This section will show you how to format the data displayed in charts

The basic interface for the Format section is as shown below:


Format Interface

Format the data displayed in charts using Labels.
Each of the measures on the chart can be customized separately. For each measure, a custom Label can be set underLabels:

Format Interface


Four different types of data can be displayed on the charts - Text, Number, Date and Duration (time-interval).
The available options for each of these types are explained below.
Formatting Text Value
Formatting Number Value
Formatting Date Values
Formatting Duration Values (Time-Intervals)

Formatting Text values



The interface for formatting text values is as shown. It provides a list of all the available values for the measure. Vizard lets you to edit these values. Click onApply,and the new values will be reflected everywhere on the chart. ClickResetto restore the original values.

Format Interface

Formatting Number values

The interface for formatting Number values is as shown below. You can use a Conversion Scheme to customise your values as shown below:

Format Interface

Creating a Conversion Scheme

Format Interface

Converting to different Units

The Data Units text-box can be used to specify the units for measures like Functions. You can select a Conversion Scheme or disable conversions by setting it to No Conversions. If the conversions are enabled, the list of possible units are populated in the Convert Units To drop-down. If you want all the values to be converted to the same units, select those units from the Convert Units To drop-down. If you select the Automatic option, then the units are dynamically selected based on what is more readable (for example, the value "100,000,000" is more readable as "100 million" than "100,000 thousands")

Formatting the converted number

You can format Number values by specifying a Spreadsheet-like format-code. Vizard supports a subset of all the format-codes supported by popular Spreadsheet tools for Numbers. If you do not specify any format-code, then a default formatting is applied using the Data Type.

Commonly used Number format-codes

Here are some of the commonly used format-codes for Numbers:

Limitations

As mentioned above, Vizard supports a subset of all the format-codes supported by Spreadsheet tools. These are some of the known limitations:

Formatting Date values

Format Interface

The interface for formatting Date values is shown above. You can use Spreadsheet-like format-codes to customize Date values. Vizard supports almost all the format-codes supported by Spreadsheet tools for Date values.

Commonly used Date format-codes

Here are some of the commonly used format-codes for Dates:

Formatting Duration (Time-Interval) values

Format Interface

The interface for formatting Duration values is shown above. Similar to the other data-types, you can specify a format-code to customize the displayed values. However, for Duration values,Vizarddoes NOT use the conventions followed in Spreadsheet tools. This is due to their inability to display a number higher than 31 for days. Instead, Vizard uses the following conventions to display time intervals.

Conventions

Commonly used Duration format-codes

Here are some of the commonly used format-codes for Durations: