{"id":11009,"date":"2017-10-20T14:44:18","date_gmt":"2017-10-20T13:44:18","guid":{"rendered":"https:\/\/help.instantatlas.com\/report-builder-agol\/?page_id=11009"},"modified":"2025-10-01T11:21:51","modified_gmt":"2025-10-01T10:21:51","slug":"bar-line-charts-confidence-limits-error-bars","status":"publish","type":"page","link":"https:\/\/help.reports.esriuk.com\/report-builder\/bar-line-charts-confidence-limits-error-bars\/","title":{"rendered":"Bar &amp; Line Charts &#8211; Confidence Limits &amp; Error Bars"},"content":{"rendered":"<p>Report Builder can show <em>confidence limits<\/em> or <em>error bars<\/em>\u00a0in <a href=\"https:\/\/help.instantatlas.com\/report-builder-agol\/widgets\/bar-chart-widget\/\">bar charts<\/a> and <a href=\"https:\/\/help.instantatlas.com\/report-builder-agol\/widgets\/line-chart-widget\/\">line charts<\/a>. These can either be calculated automatically or, more usefully, populated using an indicator from your report&#8217;s data source(s).<\/p>\n<p><a href=\"https:\/\/help.instantatlas.com\/report-builder\/wp-content\/uploads\/sites\/51\/2021\/06\/ia-rb-ci-chart-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11465\" src=\"https:\/\/help.instantatlas.com\/report-builder\/wp-content\/uploads\/sites\/51\/2021\/06\/ia-rb-ci-chart-4.png\" alt=\"InstantAtlas Report Builder line chart with error bars\" width=\"972\" height=\"510\" srcset=\"https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2021\/06\/ia-rb-ci-chart-4.png 972w, https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2021\/06\/ia-rb-ci-chart-4-300x157.png 300w, https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2021\/06\/ia-rb-ci-chart-4-768x403.png 768w\" sizes=\"auto, (max-width: 972px) 100vw, 972px\" \/><\/a><\/p>\n<h3><strong>Using Indicators as Confidence Limits<\/strong><\/h3>\n<p>To draw a chart with confidence limits you need either two or three related indicators in your data:<\/p>\n<ul>\n<li>One indicator for the values and one to give the bounds of the confidence limits<\/li>\n<li>One indicator for the values, one for the lower limit and one for the upper limit<\/li>\n<\/ul>\n<p>To access the <strong>Limits &amp; Error Bars<\/strong> settings in Report Builder, select the widget in the report and ensure that the <strong>Advanced<\/strong> button is active in the <strong>Settings<\/strong> tab on the right.<\/p>\n<p>The indicators are selected using the <strong>Data <\/strong>tab as normal. The setting that controls how they are used in the chart is <strong>Limit indicator keys<\/strong>. This is a specially-formatted list that associates indicators with each other to allow the chart to display one or more indicators as a trend line\/bar, and others as limits\/error bars. There are a number of different options for this setting, all based on this syntax:<\/p>\n<p><code>&amp;&lt;value-indicator-code-1&gt;=&lt;lower-limit-code-1&gt;,&lt;upper-limit-code-1&gt;&amp;&lt;value-indicator-code-2&gt;=&lt;lower-limit-code-2&gt;,&lt;upper-limit-code-2&gt;<\/code><\/p>\n<p>or:<\/p>\n<p><code>&amp;&lt;value-indicator-code-1&gt;=&lt;calculation-type-1&gt;:&lt;limit-indicator-code-1&gt;&amp;&lt;value-indicator-code-2&gt;=&lt;calculation-type-2&gt;:&lt;limit-indicator-code-2&gt;<\/code><\/p>\n<p>where &lt;calculation-type&gt; is one of the following:<\/p>\n<p><strong>P<\/strong> &#8211; percentage. The value from the indicator with an ID\/code\/name of &lt;limit-indicator-code&gt; is treated as a percentage of the actual data value which gives confidence limits of that percentage above and below the data value.<\/p>\n<p><strong>A<\/strong> &#8211; absolute. The value from the indicator with an ID\/code\/name of &lt;limit-indicator-code&gt; is treated as an absolute data value which gives confidence limits of that value above and below the data value.<\/p>\n<p><b>R<\/b> &#8211; range (or interval). The value from the indicator with an ID\/code\/name of &lt;limit-indicator-code&gt; is treated as an absolute data range which gives confidence limits of that half (0.5) that value above and below the data value.<\/p>\n<p>For the\u00a0<code>&amp;&lt;value-indicator-code-1&gt;=&lt;lower-limit-code-1&gt;,&lt;upper-limit-code-1&gt;<\/code> syntax all values are treated as absolute values.<\/p>\n<p>The example above uses a special form of this syntax:<\/p>\n<p><code>*=pattern:R:#INAME ~ Confidence<\/code><\/p>\n<p>In this form each part has a special value:<\/p>\n<p><code>*<\/code> a wildcard &#8211; apply the same rule to all indicators in the chart.<\/p>\n<p><code>pattern:R:#INAME ~ Confidence<\/code> &#8211; means that indicators are not matched on a static ID or name but are looked up based on the pattern supplied. So, for example #INAME is replaced with the name of the first indicator in the chart, <em>Economic activity rate &#8211; aged 16-64<\/em>, and then the limits indicator is found by matching the expanded pattern against the other indicators which matches\u00a0<em>Economic activity rate &#8211; aged 16-64 ~ Confidence<\/em>.<\/p>\n<p>This type of syntax makes it easy to use many indicators in your chart or to quickly copy-and-paste widgets and substitute new or different data, as long as you consistently use the same patterns when naming indicators. You can use this for upper and lower limits too (but omitting the calculation type, which is presumed to be <em>A<\/em>, <em>absolute<\/em> for upper and lower limits), for example:<\/p>\n<p><code>*=pattern:#INAME lower limit,#INAME upper limit\u00a0<\/code><\/p>\n<p>The images below display an example of this syntax using a report with an <a href=\"https:\/\/help.instantatlas.com\/report-builder-agol\/data-catalog\/\">InstantAtlas Data Catalog<\/a> as the data source, containing data from the National Data Service.<\/p>\n<p><a href=\"https:\/\/help.instantatlas.com\/report-builder\/wp-content\/uploads\/sites\/51\/2021\/06\/ia-rb-ci-chart.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11462\" src=\"https:\/\/help.instantatlas.com\/report-builder\/wp-content\/uploads\/sites\/51\/2021\/06\/ia-rb-ci-chart.png\" alt=\"InstantAtlas Report Builder chart with confidence limits\" width=\"976\" height=\"320\" srcset=\"https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2021\/06\/ia-rb-ci-chart.png 976w, https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2021\/06\/ia-rb-ci-chart-300x98.png 300w, https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2021\/06\/ia-rb-ci-chart-768x252.png 768w\" sizes=\"auto, (max-width: 976px) 100vw, 976px\" \/><\/a><\/p>\n<p>The indicators selected under the <strong>Data<\/strong> tab are as shown in the image below. The first indicator provides the values used to draw the chart bars, and the second and third indicators provide the values used to draw the lower and upper confidence limits respectively.<\/p>\n<p><a href=\"https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2025\/10\/DataForErrorbars.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11971\" src=\"https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2025\/10\/DataForErrorbars.png\" alt=\"\" width=\"670\" height=\"360\" srcset=\"https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2025\/10\/DataForErrorbars.png 670w, https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2025\/10\/DataForErrorbars-300x161.png 300w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/a><\/p>\n<p>The settings under the <strong>Limits &amp; Error Bars<\/strong> heading for this chart were set as shown in the image below.<\/p>\n<p><a href=\"https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2023\/07\/rb-2-6-ci2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11789\" src=\"https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2023\/07\/rb-2-6-ci2.png\" alt=\"Chart limits rule example\" width=\"662\" height=\"480\" srcset=\"https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2023\/07\/rb-2-6-ci2.png 662w, https:\/\/help.reports.esriuk.com\/report-builder\/wp-content\/uploads\/sites\/51\/2023\/07\/rb-2-6-ci2-300x218.png 300w\" sizes=\"auto, (max-width: 662px) 100vw, 662px\" \/><\/a><\/p>\n<p>The <strong>Limits indicators key<\/strong> is set to the following:<\/p>\n<p><code>*=pattern:#INAME (Lower 95% Confidence Limit),#INAME (Upper 95% Confidence Limit)<\/code><\/p>\n<p>This specifies that the lower and upper limits will be provided by indicators with the same name as the base indicator but with <em>(Lower 95% Confidence Limit)<\/em> or <em>(Lower 95% Confidence Limit)<\/em> appended.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Report Builder can show confidence limits or error bars\u00a0in bar charts and line charts. These can either be calculated automatically or, more usefully, populated using an indicator from your report&#8217;s data source(s). Using Indicators as Confidence Limits To draw a chart with confidence limits you need either two or three related indicators in your data: [&hellip;]<\/p>\n","protected":false},"author":61,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-11009","page","type-page","status-publish","hentry","entry"],"_links":{"self":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/pages\/11009","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/users\/61"}],"replies":[{"embeddable":true,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/comments?post=11009"}],"version-history":[{"count":0,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/pages\/11009\/revisions"}],"wp:attachment":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/media?parent=11009"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}