Line Chart Examples

image_pdfimage_print

Preliminary remarks:
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
Check “Formatted values” 1) (if unchecked “serial numbers” will be displayed instead of “Month Year” at the X axis)
Group data by: Auto
Series labels: Auto
Category labels: Auto

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” 1)  and the chart on the right if you check “Formatted values” for chart creation:

Example 3: Stock chart

Version 1:
Default chart

Chart selection: Stock – Stock Line with Markers  
Source data: A1:B14
Group data by: Auto
Series labels: Auto
Category labels: Auto

Note: don’t check “Formatted values” 1) (if checked no chart will be created because this chart type expects “serial numbers” and would format them itself)

 1) Note to “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

  1. if one axe shows time values (like in Example 1).
  2. if you have attributes for the elements (like in Example 2)

In all other cases it makes no sense to use the checkbox “Formatted Values”. And you should never use it 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”. But this command is not available for all chart types!

 Version 2:
This version has different colors and a customized interface. To create this version, use the context menu command “Format Chart Properties – Range Selector” with following settings:

Result:

Before using the Input Range Selector and the buttons of the Navigator, you should lock the chart with the context menu command.

The Navigator has arrow keys, a scroll button, and a left and right range-limit button.

Although the image above shows only 2 months selected with the range limit buttons, there must be a minimum of 5 values displayed in the chart. Also note that the Y axis is adapted to show only the displayed values (value 90000 is no longer displayed).

Example 4: Stock line chart for currency history

Chart selection: Stock – Stock Line with Markers  
Source data: A1:B91
Don’t check “Formatted values”
Group data by: Auto
Series labels: Auto
Category labels: Auto

With Zoom 1m, the Y axis is adapted to show only the displayed values:

 

image_pdfimage_print
Was this post helpful?
NoYes (+2 rating, 2 votes)
Loading...