Stock Chart Examples


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: Default Stock Chart

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

Don’t check “Formatted values”.  If checked, no chart will be created because this chart type expects serial numbers and would format them itself.

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

  1. if one axis 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 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: Custom Stock Chart

This version of the stock chart above has different colors and a customized interface. To create this version, right-click on the stock chart you created in the example above and select “Format Chart Properties” from the context menu. The dialog below will appear. Select “Range Selector” from the Category list.


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: Stock Line Chart for Currency History

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

Don’t check “Formatted values”. With Zoom 1m, the Y axis is adapted to show only the displayed values:


Was this post helpful?
NoYes (+1 rating, 1 votes)