The Trend Bars tab will format the cells in the current column so that each cell contains a series of colored boxes, where each colored box represents the cell value as of a certain bar. So, for example, if you select the Trend Bars formatting using the default values, 5 colored boxes will be displayed in each cell in the current column. The color of each box will be green if the value as of that bar is higher than the value as of the prior bar, red if the value as of that bar is lower than the value as of the prior bar, or yellow if the value is the same as the value as of the prior bar. This would allow you to visualize the trend of the values over the most recent 5 bars.
Once you apply this formatting to a column, adjust the Row Height and Column Width as necessary to achieve the look that you want.
Note: After formatting has been applied to the Grid you can double-click anywhere in the Grid to temporarily hide all formatting so that you can quickly view the underlying numbers. Double-click again and the formatting will return.
Trend Bars formatting page
| • | Trend Frame Color: Use this color selector to set the outline color for the trend bar boxes. |
| • | Trend Up Color: Use this color selector to set the color to be used for an up trend. |
| • | Trend Neutral Color: Use this color selector to set the color to be used for a neutral trend. |
| • | Trend Down Color: Use this color selector to set the color to be used for a down trend. |
| • | Trend Bars to Plot: Select the number of boxes to plot in each cell. Each box represents the cell value as of a certain bar. The rightmost box represents the current cell value, the next box to the left represents the cell value as of the prior bar, the next box after that represents the cell value as of two bars ago, etc. |
Click on the Cancel button or press the ESC key to cancel any changes and close the Format Column dialog.
Click on the Apply button to apply the changes and close the Format Column dialog.
Click on the Reset All button to remove all formatting settings for all columns.
Trend Bars formatting example
Note: Once you have applied formatting to the Grid, that formatting remains with the associated script. If you then modify the script by adding or removing columns, the formatting may need to be adjusted.
See also: