# Cell Binding on Easy Chart

**URL:** <https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585>\
**Category:** Ignition\
**Created:** [November 19, 2013, 4:15pm UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585 "2013-11-19T16:15:16Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![jay](https://avatars.discourse-cdn.com/v4/letter/j/ed8c4c/32.png) [@jay](https://forum.inductiveautomation.com/u/jay)\
**Post date:** [November 19, 2013, 4:15pm UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/1 "2013-11-19T16:15:16Z")

</div>

I am trying to use cell binding to link a set of dropdown text boxes with TagPaths in the TAG\_PATH column of an Easy Chart. The problem I am having is that the Tag Pens dataset in the Easy Chart does not maintain a consistent row order.

In the image below, I first created the Tag Pens dataset with the Names row in the order 01, 02, 03. When I re-open this dataset the order is changed and so are the bindings.

How do I avoid this problem?

---

<div class="post-metadata">

**Author:** ![dave.fogle](https://avatars.discourse-cdn.com/v4/letter/d/43a26b/32.png) [@dave.fogle](https://forum.inductiveautomation.com/u/dave.fogle)\
**Post date:** [November 19, 2013, 11:24pm UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/2 "2013-11-19T23:24:36Z")

</div>

How exactly are you creating the tag pens dataset? Are you adding pens through the customizer or are you creating through scripting somehow?

---

<div class="post-metadata">

**Author:** ![adamaustin](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\
**Post date:** [November 20, 2013, 12:04am UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/3 "2013-11-20T00:04:29Z")

</div>

I’m not sure about the Easy chart but I have reported a similar problem [here](http://www.inductiveautomation.com/forum/viewtopic.php?f=70&t=11390).

---

<div class="post-metadata">

**Author:** ![jay](https://avatars.discourse-cdn.com/v4/letter/j/ed8c4c/32.png) [@jay](https://forum.inductiveautomation.com/u/jay)\
**Post date:** [November 20, 2013, 3:56am UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/4 "2013-11-20T03:56:49Z")

</div>

How exactly are you creating the tag pens dataset?

I am initially populating the Tag Pens dataset through the Easy Chart customizer. I have also tried entering new Tag Pens rows directly into the dataset with the Dataset Viewer. The row order is still not retained.

---

<div class="post-metadata">

**Author:** ![dave.fogle](https://avatars.discourse-cdn.com/v4/letter/d/43a26b/32.png) [@dave.fogle](https://forum.inductiveautomation.com/u/dave.fogle)\
**Post date:** [November 20, 2013, 4:44pm UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/5 "2013-11-20T16:44:54Z")

</div>

What looks like is happening is when ever you open the easy chart customizer and then click ok it reorganizes the dataset into alphabetical order by tag path. If you don't use the easy chart customizer to add tags then they will stay in the order in which you added them. But if you ever open the customizer after that and click ok then they'll be rearranged again. I'll add a ticket in for this and see if something can be done about it or not.

---

<div class="post-metadata">

**Author:** ![jay](https://avatars.discourse-cdn.com/v4/letter/j/ed8c4c/32.png) [@jay](https://forum.inductiveautomation.com/u/jay)\
**Post date:** [November 21, 2013, 1:03am UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/6 "2013-11-21T01:03:34Z")

</div>

FYI, the dataset rows are not sorted by Tag Path. I tried that.

---

<div class="post-metadata">

**Author:** ![Pat](https://avatars.discourse-cdn.com/v4/letter/p/8491ac/32.png) [@Pat](https://forum.inductiveautomation.com/u/Pat)\
**Post date:** [November 21, 2013, 3:21pm UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/7 "2013-11-21T15:21:40Z")

</div>

Make sure in the Easy Chart properties, under Layout you have Alphabetize Pens to False.

---

<div class="post-metadata">

**Author:** ![jay](https://avatars.discourse-cdn.com/v4/letter/j/ed8c4c/32.png) [@jay](https://forum.inductiveautomation.com/u/jay)\
**Post date:** [November 21, 2013, 6:09pm UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/8 "2013-11-21T18:09:35Z")

</div>

Thank you Pat !

The Alphabetize Pens property had to be unchecked, even though I was not displaying the pens.

---

<div class="post-metadata">

**Author:** ![jay](https://avatars.discourse-cdn.com/v4/letter/j/ed8c4c/32.png) [@jay](https://forum.inductiveautomation.com/u/jay)\
**Post date:** [November 21, 2013, 7:01pm UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/9 "2013-11-21T19:01:51Z")

</div>

Never mind that last one. Even with Alphabetize Pens unchecked, it still reorders the rows.

---

<div class="post-metadata">

**Author:** ![Pat](https://avatars.discourse-cdn.com/v4/letter/p/8491ac/32.png) [@Pat](https://forum.inductiveautomation.com/u/Pat)\
**Post date:** [November 21, 2013, 8:09pm UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/10 "2013-11-21T20:09:49Z")

</div>

There is a disconnect with the pen order between the Easy Chart customizer and the Tag Pens dataset. What I ended up doing is deselecting Alphabetize Pens, used the customizer to add the pens I wanted, then went to the dataset and manually edited the dataset to have the pens appear in the order I wanted.

One problem with the customizer is if you add a pen it gets added to the top of the list, it would be better if a new pen was added to the bottom of the list. Another problem with the customizer is if you add a pen and save, the pen order gets changed. The customizer doesn’t appear to get the pen order from the Tag Pens dataset. What’s going on between the disconnect I don’t know, it’s goofy.

---

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [November 21, 2013, 9:05pm UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/11 "2013-11-21T21:05:36Z")

</div>

if you are decent at scripting, you can write a script to populate the easy chart datasets when the window opens up. you can control the order like that and can easily pass in parameters to duplicate what you are doing with the cell bindings.

---

<div class="post-metadata">

**Author:** ![dave.fogle](https://avatars.discourse-cdn.com/v4/letter/d/43a26b/32.png) [@dave.fogle](https://forum.inductiveautomation.com/u/dave.fogle)\
**Post date:** [November 21, 2013, 10:39pm UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/12 "2013-11-21T22:39:57Z")

</div>

Whenever I add a pen using the customizer it's added in alphabetical order by the tag path. Whenever I drag and drop a pen on the chart they are added to the dataset in the order that i dropped them. Alphabetical order being:  
1  
12 ab  
d\_10  
d\_2  
d\_6  
hello

This is when I test it in 7.6.3. What version are you using where you are seeing different results? Am I doing something different than you?

---

<div class="post-metadata">

**Author:** ![jay](https://avatars.discourse-cdn.com/v4/letter/j/ed8c4c/32.png) [@jay](https://forum.inductiveautomation.com/u/jay)\
**Post date:** [November 22, 2013, 12:21am UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/13 "2013-11-22T00:21:57Z")

</div>

I see what the problem is now. The row reordering is caused by the Customizer.

The first screen shot shows my Tag Pens in the order I want them for my Cell Update bindings to work.

Then I open the Customizer as shown in the second screen shot. The Customizer sorts the pens by Tag Path. I press OK.

Then the tags are reorder in the dataset as shown in the last screen shot.

I don’t think the Customizer should be sorting the Tag Pens rows at all, especially by Tag Paths unless the user specifically tells it to. Doing so causes the Cell Updates binding to be misaligned. Six of my Cell Update bindings are to the Tag Paths. You can’t sort by those since they are dynamic.

---

<div class="post-metadata">

**Author:** ![dave.fogle](https://avatars.discourse-cdn.com/v4/letter/d/43a26b/32.png) [@dave.fogle](https://forum.inductiveautomation.com/u/dave.fogle)\
**Post date:** [November 22, 2013, 7:11pm UTC](https://forum.inductiveautomation.com/t/cell-binding-on-easy-chart/7585/14 "2013-11-22T19:11:40Z")

</div>

Ok, that's what I thought was happening. I'll put in a request to see if the customizer can just append tags to the end of the dataset instead of reordering them.
