# 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:** 1\
**Showing post:** 4

<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.

---

_[View the full topic](https://forum.inductiveautomation.com/t/box-and-whisker-chart-cell-update-approach/82977)._