# Box and Whisker Chart cell update approach

**URL:** <https://forum.inductiveautomation.com/t/box-and-whisker-chart-cell-update-approach/82977>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [December 11, 2023, 2:52pm UTC](https://forum.inductiveautomation.com/t/box-and-whisker-chart-cell-update-approach/82977 "2023-12-11T14:52:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Callmesoon](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@Callmesoon](https://forum.inductiveautomation.com/u/Callmesoon)\
**Post date:** [December 11, 2023, 2:52pm UTC](https://forum.inductiveautomation.com/t/box-and-whisker-chart-cell-update-approach/82977/1 "2023-12-11T14:52:15Z")

</div>

Dear all,

I would like to know if the box-and-whisker chart will update automatically when I use cell updates in the row and column by binding the value to a tag which will change constantly.

If it will not update automatically, i appreciate it if you can give me a suggestion that would help me.

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [December 11, 2023, 3:35pm UTC](https://forum.inductiveautomation.com/t/box-and-whisker-chart-cell-update-approach/82977/2 "2023-12-11T15:35:23Z")

</div>

> [@Callmesoon](#):
>
> when I use cell updates in the row and column by binding the value to a tag

Just to make sure I understand, you are binding the data property of the chart to a dataset tag?  
...or you are using a cell update binding to individual tags?

---

<div class="post-metadata">

**Author:** ![Callmesoon](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@Callmesoon](https://forum.inductiveautomation.com/u/Callmesoon)\
**Post date:** [December 11, 2023, 9:23pm UTC](https://forum.inductiveautomation.com/t/box-and-whisker-chart-cell-update-approach/82977/3 "2023-12-11T21:23:39Z")

</div>

> [@Callmesoon](#):
>
> I use cell updates in the row and column by bin

i am using cell update to binding to individual tags

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [December 12, 2023, 3:46am UTC](https://forum.inductiveautomation.com/t/box-and-whisker-chart-cell-update-approach/82977/4 "2023-12-12T03:46:05Z")

</div>

Interesting. Experimenting with this chart, I could only get it to update if the number of rows changed. Changing individual values had no effect. Also, the normal methods for triggering a repaint didn't work, and the data propertyChange event for the chart never happens, even when a row number change causes an update.

As a work around, I created a dataset custom property on the chart's parent container, _[the chart itself doesn't have a custom property option],_ and I set up my cell update binding there. Then, I scripted the data update in this way:

```auto
# On the chart's parent's propertyChange event handler
# If the data changes in some way...
if event.propertyName == 'data':
	# Get the data from the container's custom data property
	data = event.source.data
	
	# Get the chart component
	chart = event.source.getComponent('Box and Whisker Chart')
	
	# Wipe the chart's dataset, and replace it to trigger an update
	chart.data = system.dataset.toDataSet(['empty'], [])
	chart.data = data

```

It's not the most intuitive approach, but it will work until you come up with something better.