# Show Range

The Range feature enables you to show additional range information on a chart. It is available in Line and Scatter (No Aggregation) charts.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2Fec716a2ff42c1dd2dab7687006afc3ca224ae277.png?generation=1599717435933420\&alt=media)

## Setup the Range

You can set up the range from the Range Dialog. You can find the Range Dialog in the Y-Axis menu dropdown.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2F579d282a3d0726e4469f5cc224228ccb8feb0b18.png?generation=1599717399910769\&alt=media)

## Range Types

There are 2 range types available.

* Confidence Interval
* Column
* Specific Value

### Confidence Interval

The Confidence Interval option calculates confidence interval ranges from data and shows them automatically on a chart. You can show confidence interval ranges by selecting the "Confidence Interval" from the Range Type menu in the Range Setting Dialog.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2Fb20f9ba803341584e8ca043b60efebe5d43a1ab9.png?generation=1599717398886354\&alt=media)

There are the following options available for Range Function.

* 90% Condfidence Interval
* 95% Condfidence Interval
* 99% Condfidence Interval
* Standard Error

Note that Confidence Interval is available only in Line chart, and is available for Mean, % of TRUE, and % of FALSE functions without Window Calculation being applied on Y-Axis.

### Column

If you already have columns for upper and lower limit values for the values on Y-Axis, you can show them as ranges in the same chart.

You can select "Custom" from the Range Type menu and assign columns for Upper Limit values and Lower Limit values.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2Fef55c32bb75b58f3d7fdd910eb2ffc21abf8f0d9.png?generation=1599717396829431\&alt=media)

Columns will be automatically picked and assigned for your convenience if you have one of the following column pairs in the same data frame.

* `(Y-Axis Column Name)_high` and `(Y-Axis Column Name)_low`
* `(Y-Axis Column Name).high` and `(Y-Axis Column Name).low`
* `(Y-Axis Column Name)_upper` and `(Y-Axis Column Name)_lower`
* `(Y-Axis Column Name).upper` and `(Y-Axis Column Name).lower`
* `(Y-Axis Column Name)_higher` and `(Y-Axis Column Name)_lower`
* `(Y-Axis Column Name).higher` and `(Y-Axis Column Name).lower`
* `conf_high` and `conf_low`
* `conf.high` and `conf.low`

### Specific Value

You can specify the range by setting the upper and lower value manually.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M4HLCK3olgduYoe3RVS%2Fuploads%2Fgit-blob-d310e2e198701ad62e57c701197229e6ffea3e85%2Frange3.png?alt=media)

## Range in Line Chart

The following range types are available in Line chart.

* Confidence Interval
* Custom

In Line chart, ranges will be displayed as range bands like the following.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2F4cb9e54cb292c001a114d43425b597e15b8e8528.png?generation=1599717396074889\&alt=media)

## Range in Scatter (No Aggregation) Chart

The following range types are available in Scatter (No Aggregation) Chart

* Custom

In Scatter (No Aggregation) chart, ranges will be displayed as error bars like the following.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2Fc92b5dfe6ca5c497bad1d20050d2ad66b12bfa7e.png?generation=1599717398037059\&alt=media)

You can optionally set the error bar width in Range Dialog. The default width is `4` in pixel.