change background color of an individual cell in the data editor...

[LSanders]

My users want to see a basic line chart of a data value.. (no problem).  They want each point displayed in the data editor.  (no problem).  Then, they want an individual cell in the data editor to have a background color of yellow if the % change is > 10 and the background color of the cell to be red if the % change > 20. 

 I do not see a way to change the background color of an individual cell in the data editor.  Is this possible??

[maximop]

To set the background color of the data editor's cells you need to set the BackColorData property of the DataEditorObj. You can do the following:

Chart1.DataEditorObj.BackColorData = RGB(0,0,255)

Unfortunately, this will set the background color for all cells. In this version of ChartFX, you cannot set individual attributes for the data editor's cells.