For the examples with time values at the X axis, the X-axis labels (column A) have to be valid date-time stamps. If you don’t have daily values, you still have to use valid date-time stamps, such as the first day of every month.
The time values have to be before all other data (as first column of the chart’s data source). The column with the time values cannot have a header.
Example 1: Line Chart
Chart selection: Lines – Lines
Source data: A1:C14
Group data by: Auto
Series labels: Auto
Category labels: Auto
Check “Formatted values”. If unchecked, serial numbers will be displayed instead of “Month Year” at the X axis.
Important note regarding formatted values: the examples presented above show that the result of opting for “Formatted Values” will depend on the data and the chart type used. This option only impacts the label of the X axis and/or the legend.
It only makes sense to use “Formatted Values” in charts under the following conditions:
- One axis shows time values (as in Example 1)
- Elements have attributes (as in Example 2)
In all other cases, it makes no sense to use the checkbox “Formatted Values”, and it should never be used for stock charts.
Checking or unchecking “Formatted Values” has no influence on the displayed dynamic value in the chart. This displayed value depends only on the selected chart type and, if possible, the formatting done with the context menu command “Format Data Series…. – Numbers”. Note that this command is not available for all chart types.
Example 2: Line Chart with Adapted Legend
In the following Jedox view, the row and column titles are formatted with a custom type called ;;;”German Translation”
See screen shot below. You receive the chart on the left if you don’t check “Formatted values” and the chart on the right if you check “Formatted values” for chart creation. See note above regarding formatted values.