# \[BUG\] XY Chart Candlestick **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [August 11, 2021, 2:29pm UTC](https://forum.inductiveautomation.com/t/bug-xy-chart-candlestick/49812 "2021-08-11T14:29:34Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![jgooding](https://avatars.discourse-cdn.com/v4/letter/j/a88e4f/32.png) [@jgooding](https://forum.inductiveautomation.com/u/jgooding)\ **Post date:** [August 11, 2021, 2:29pm UTC](https://forum.inductiveautomation.com/t/bug-xy-chart-candlestick/49812/1 "2021-08-11T14:29:34Z")
Can someone tell me if it is possible to make a chart like this in the XY Chart Tool in Perspective? I tried to make a candlestick with the with each series running from the zone to zone but that does not appear to work? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/1/516b28100f1460f1432094f76a21d4b2d4c9024e.png) [http://software.es.net/react-timeseries-charts/#/example/trend](http://software.es.net/react-timeseries-charts/#/example/trend) I tried creating each swipe as candlestick but that does not seem to work. Any help or pointers to read up more on the xy chart and options would be helpful. ---
**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\ **Post date:** [August 11, 2021, 3:07pm UTC](https://forum.inductiveautomation.com/t/bug-xy-chart-candlestick/49812/2 "2021-08-11T15:07:11Z")
what is not working? what do you see? ---
**Author:** ![jgooding](https://avatars.discourse-cdn.com/v4/letter/j/a88e4f/32.png) [@jgooding](https://forum.inductiveautomation.com/u/jgooding)\ **Post date:** [August 11, 2021, 3:49pm UTC](https://forum.inductiveautomation.com/t/bug-xy-chart-candlestick/49812/3 "2021-08-11T15:49:36Z")
I get no bars. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/b/9b5c4487a053b770e1e14567818e1f1b2821438e.png) ```auto [ { "type": "ia.chart.xy", "version": 0, "props": { "xAxes": [ { "name": "Sample", "label": { "enabled": true, "text": "Time", "color": "" }, "visible": true, "tooltip": { "enabled": true, "text": "", "cornerRadius": 3, "pointerLength": 4, "background": { "color": "", "opacity": 1 } }, "inversed": false, "render": "category", "category": { "break": { "enabled": false, "startCategory": "", "endCategory": "", "size": 0.05 } }, "date": { "baseInterval": { "enabled": false, "timeUnit": "hour", "count": 1, "skipEmptyPeriods": false }, "range": { "max": "", "min": "", "useStrict": false }, "break": { "enabled": false, "startDate": "", "endDate": "", "size": 0.05 }, "inputFormat": "yyyy-MM-dd kk:mm:ss", "format": "M/d" }, "value": { "range": { "max": "", "min": "", "useStrict": false }, "logarithmic": false, "break": { "enabled": false, "startValue": 0, "endValue": 100, "size": 0.05 }, "format": "#,###.##" }, "appearance": { "opposite": false, "inside": false, "labels": { "color": "", "opacity": 1 }, "grid": { "color": "", "opacity": 1, "dashArray": "", "minDistance": 60, "position": 0.5 }, "font": { "size": "", "weight": 500 } } } ], "yAxes": [ { "name": "Value", "label": { "enabled": true, "text": "Random\n", "color": "" }, "visible": true, "tooltip": { "enabled": true, "text": "", "cornerRadius": 3, "pointerLength": 4, "background": { "color": "", "opacity": 1 } }, "inversed": false, "render": "value", "category": { "break": { "enabled": false, "startCategory": "", "endCategory": "", "size": 0.05 } }, "date": { "baseInterval": { "enabled": false, "timeUnit": "minute", "count": 1, "skipEmptyPeriods": false }, "range": { "max": "", "min": "", "useStrict": false }, "break": { "enabled": false, "startDate": "", "endDate": "", "size": 0.05 }, "inputFormat": "yyyy-MM-dd kk:mm:ss", "format": "M/d/yyyy HH:mm:ss" }, "value": { "range": { "max": "", "min": "", "useStrict": false }, "logarithmic": false, "break": { "enabled": false, "startValue": 0, "endValue": 100, "size": 0.05 }, "format": "#,###.##" }, "appearance": { "opposite": false, "inside": false, "labels": { "color": "", "opacity": 1 }, "grid": { "color": "", "opacity": 1, "dashArray": "", "minDistance": null, "position": 0.5 }, "font": { "size": "", "weight": 500 } } } ], "series": [ { "name": "Value", "label": { "text": "RandomData" }, "visible": true, "hiddenInLegend": false, "defaultState": { "visible": true }, "data": { "source": "example", "x": "Sample", "y": "Value" }, "xAxis": "Sample", "yAxis": "Value", "zIndex": 0, "tooltip": { "enabled": true, "text": "{name}: [bold]{valueY}[/]", "cornerRadius": 3, "pointerLength": 4, "background": { "color": "", "opacity": 1 } }, "render": "candlestick", "candlestick": { "open": { "x": "Sample", "y": "Value" }, "high": { "x": "Sample", "y": "Zone3UL" }, "low": { "x": "Sample", "y": "Zone3LL" }, "appearance": { "fill": { "color": "", "opacity": 1 }, "stroke": { "color": "", "opacity": 1, "width": 1 }, "stacked": false, "deriveFieldsFromData": { "fill": { "color": "", "opacity": "" }, "stroke": { "color": "", "opacity": "", "width": "" } }, "heatRules": { "enabled": false, "max": "", "min": "", "dataField": "" } } }, "column": { "open": { "x": "", "y": "" }, "appearance": { "fill": { "color": "", "opacity": 1 }, "stroke": { "color": "", "opacity": 1, "width": 1 }, "stacked": false, "width": null, "height": null, "deriveFieldsFromData": { "fill": { "color": "", "opacity": "" }, "stroke": { "color": "", "opacity": "", "width": "" } }, "heatRules": { "enabled": false, "max": "", "min": "", "dataField": "" } } }, "line": { "open": { "x": "", "y": "" }, "appearance": { "connect": true, "tensionX": 1, "tensionY": 1, "minDistance": 0.5, "stroke": { "width": 3, "opacity": 1, "color": "", "dashArray": "" }, "fill": { "opacity": 0, "color": "" }, "bullets": [ { "enabled": false, "render": "circle", "width": 10, "height": 10, "label": { "text": "{value}", "position": { "dx": 0, "dy": 0 } }, "fill": { "color": "", "opacity": 1 }, "stroke": { "color": "", "opacity": 1, "width": 1 }, "rotation": 0, "tooltip": { "enabled": true, "text": "{name}: [bold]{valueY}[/]", "cornerRadius": 3, "pointerLength": 4, "background": { "color": "", "opacity": 1 } }, "deriveFieldsFromData": { "fill": { "color": "", "opacity": "" }, "stroke": { "color": "", "opacity": "", "width": "" }, "rotation": "" }, "heatRules": { "enabled": false, "max": 100, "min": 2, "dataField": "" } } ] } }, "stepLine": { "open": { "x": "", "y": "" }, "appearance": { "connect": true, "tensionX": 1, "tensionY": 1, "minDistance": 0.5, "stroke": { "width": 3, "opacity": 1, "color": "", "dashArray": "" }, "fill": { "opacity": 0, "color": "" }, "bullets": [ { "enabled": true, "render": "circle", "width": 10, "height": 10, "label": { "text": "{value}", "position": { "dx": 0, "dy": 0 } }, "fill": { "color": "", "opacity": 1 }, "stroke": { "color": "", "opacity": 1, "width": 1 }, "rotation": 0, "tooltip": { "enabled": true, "text": "{name}: [bold]{valueY}[/]", "cornerRadius": 3, "pointerLength": 4, "background": { "color": "", "opacity": 1 } }, "deriveFieldsFromData": { "fill": { "color": "", "opacity": "" }, "stroke": { "color": "", "opacity": "", "width": "" }, "rotation": "" }, "heatRules": { "enabled": false, "max": 100, "min": 2, "dataField": "" } } ] } } }, { "name": "Value", "label": { "text": "RandomData" }, "visible": true, "hiddenInLegend": false, "defaultState": { "visible": true }, "data": { "source": "example", "x": "Sample", "y": "Value" }, "xAxis": "Sample", "yAxis": "Value", "zIndex": 0, "tooltip": { "enabled": true, "text": "{name}: [bold]{valueY}[/]", "cornerRadius": 3, "pointerLength": 4, "background": { "color": "", "opacity": 1 } }, "render": "step line", "candlestick": { "open": { "x": "Sample", "y": "Value" }, "high": { "x": "Sample", "y": "Zone3UL" }, "low": { "x": "Sample", "y": "Zone3LL" }, "appearance": { "fill": { "color": "", "opacity": 1 }, "stroke": { "color": "", "opacity": 1, "width": 1 }, "stacked": false, "deriveFieldsFromData": { "fill": { "color": "", "opacity": "" }, "stroke": { "color": "", "opacity": "", "width": "" } }, "heatRules": { "enabled": false, "max": "", "min": "", "dataField": "" } } }, "column": { "open": { "x": "", "y": "" }, "appearance": { "fill": { "color": "", "opacity": 1 }, "stroke": { "color": "", "opacity": 1, "width": 1 }, "stacked": false, "width": null, "height": null, "deriveFieldsFromData": { "fill": { "color": "", "opacity": "" }, "stroke": { "color": "", "opacity": "", "width": "" } }, "heatRules": { "enabled": false, "max": "", "min": "", "dataField": "" } } }, "line": { "open": { "x": "", "y": "" }, "appearance": { "connect": true, "tensionX": 1, "tensionY": 1, "minDistance": 0.5, "stroke": { "width": 3, "opacity": 1, "color": "", "dashArray": "" }, "fill": { "opacity": 0, "color": "" }, "bullets": [ { "enabled": false, "render": "circle", "width": 10, "height": 10, "label": { "text": "{value}", "position": { "dx": 0, "dy": 0 } }, "fill": { "color": "", "opacity": 1 }, "stroke": { "color": "", "opacity": 1, "width": 1 }, "rotation": 0, "tooltip": { "enabled": true, "text": "{name}: [bold]{valueY}[/]", "cornerRadius": 3, "pointerLength": 4, "background": { "color": "", "opacity": 1 } }, "deriveFieldsFromData": { "fill": { "color": "", "opacity": "" }, "stroke": { "color": "", "opacity": "", "width": "" }, "rotation": "" }, "heatRules": { "enabled": false, "max": 100, "min": 2, "dataField": "" } } ] } }, "stepLine": { "open": { "x": "", "y": "" }, "appearance": { "connect": true, "tensionX": 1, "tensionY": 1, "minDistance": 0.5, "stroke": { "width": 3, "opacity": 1, "color": "", "dashArray": "" }, "fill": { "opacity": 0, "color": "" }, "bullets": [ { "enabled": true, "render": "circle", "width": 10, "height": 10, "label": { "text": "{value}", "position": { "dx": 0, "dy": 0 } }, "fill": { "color": "", "opacity": 1 }, "stroke": { "color": "", "opacity": 1, "width": 1 }, "rotation": 0, "tooltip": { "enabled": true, "text": "{name}: [bold]{valueY}[/]", "cornerRadius": 3, "pointerLength": 4, "background": { "color": "", "opacity": 1 } }, "deriveFieldsFromData": { "fill": { "color": "", "opacity": "" }, "stroke": { "color": "", "opacity": "", "width": "" }, "rotation": "" }, "heatRules": { "enabled": false, "max": 100, "min": 2, "dataField": "" } } ] } } } ], "dataSources": { "example": [ { "Sample": "1", "Value": "47", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "2", "Value": "26", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "3", "Value": "1", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "4", "Value": "45", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "5", "Value": "17", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "6", "Value": "6", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "7", "Value": "1", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "8", "Value": "25", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "9", "Value": "5", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "10", "Value": "47", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "11", "Value": "35", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "12", "Value": "1", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "13", "Value": "41", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "14", "Value": "11", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "15", "Value": "20", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "16", "Value": "36", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "17", "Value": "29", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "18", "Value": "5", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "19", "Value": "7", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "20", "Value": "42", "Zone3LL": "0", "Zone2LL": "7", "Zone1LL": "15", "Zone1UL": "35", "Zone2UL": "43", "Zone3UL": "50" }, { "Sample": "" } ] } }, "meta": { "name": "XYChart_0" }, "position": { "x": 12, "y": 53, "height": 657, "width": 773 }, "custom": {} } ] ``` ---
**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\ **Post date:** [August 12, 2021, 8:43am UTC](https://forum.inductiveautomation.com/t/bug-xy-chart-candlestick/49812/5 "2021-08-12T08:43:36Z")
Acutally i think the candle chart doesnt work yet. because candlesticks should have 4 props not 3 : high open close low yet ignition has just 3. very weird Has anyone ever made a candlestick chart? @cmallonee pretty sure this is a bug I went ahead and changed the title for you ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [August 12, 2021, 4:43pm UTC](https://forum.inductiveautomation.com/t/bug-xy-chart-candlestick/49812/6 "2021-08-12T16:43:27Z")
I was able to get this working (after requesting some help form the Dev who implemented the chart). Here are the important pieces for setting up a "standard" candlestick chart: #### Underlying data: The object for each data entry will need to supply five pieces of data: date, high, low, open, close. Going forward in my example, we will use those five values as keys. ![Screen Shot 2021-08-12 at 9.38.11 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/4/c446d50da65b0ba644699a9255851fda9fac5323.png) #### Axes: I have only one entry for `xAxes` and one entry for `yAxes`. My `xAxes` entry is named "dateAxis", and my `yAxes` entry is named "valuation". #### Series: With those aforementioned settings in place, the following configuration displayed a candlestick chart. - Note that `series.data.y` is set to close, and that there is no `candlestick.close` property. I have no idea why it was implemented this way, but I _suspect_ it was because the underlying library probably requires a `y` value be supplied, and so in some way it made sense to default to that y value for the close. 🤷‍♂️ ![Screen Shot 2021-08-12 at 9.34.53 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/d/cdfda5cb1bedd9102d420a543c11a672c525815b.png) #### Result: ![Screen Shot 2021-08-12 at 9.42.00 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/a/2aa95e39de176ac766afb901eee6dbd51f2795d5.png) #### Known issue: We are aware of [this issue](https://forum.inductiveautomation.com/t/bug-perspective-xy-chart-candlestick-low-value-not-rendering-correctly/48676) reported recently in regard to the "low" value always appearing to be `0`. ---
**Author:** ![jgooding](https://avatars.discourse-cdn.com/v4/letter/j/a88e4f/32.png) [@jgooding](https://forum.inductiveautomation.com/u/jgooding)\ **Post date:** [August 12, 2021, 6:53pm UTC](https://forum.inductiveautomation.com/t/bug-xy-chart-candlestick/49812/7 "2021-08-12T18:53:30Z")
Can the requirement for the x-axis be a date be changed to allow it to be categories? Can we improve the documentation? None of this explained in the documentation. Thanks (sorry for the rant), I am normally a fan of most things Inductive Automation and Ignition. ---
**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\ **Post date:** [August 13, 2021, 6:35am UTC](https://forum.inductiveautomation.com/t/bug-xy-chart-candlestick/49812/8 "2021-08-13T06:35:56Z")
i agree this example should be in the docs too, as it only has 2 examples and this candlestick definitly needs one as its quite different^^ ---
**Author:** ![Paul.Scott](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul.scott/32/4578_2.png) [@Paul.Scott](https://forum.inductiveautomation.com/u/Paul.Scott)\ **Post date:** [August 16, 2021, 4:54pm UTC](https://forum.inductiveautomation.com/t/bug-xy-chart-candlestick/49812/9 "2021-08-16T16:54:50Z")
For posterity, I ended up incorporating Cody’s example into the [user manual](https://docs.inductiveautomation.com/display/DOC81/XY+Chart+Example+-+Candlestick+Chart).