The Fill Chart tab will format the contents of each cell in the current column in the form of an embedded fill chart (aka, area fill chart). So instead of seeing just the current value displayed in each cell, you will instead see a fill-style plot of the values over several 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.
Fill Chart formatting page
| • | Fill Chart Plot Color: Use this color selector to set the outline color for the plot area. |
| • | Fill Chart Axis Color: Use this color selector to set the color for the chart axis. |
| • | Fill Chart Area Color: Use this color selector to set the color for the plot area. |
| • | Fill Chart Fill Color: Use this color selector to set the background or fill color for each cell. |
| • | Bars to Plot: Select the number of bars that should be used to create the fill chart plot. |
| • | Upr Ref: Select the value at which an upper reference line should be drawn, if applicable. You can also select the color to be used to draw the reference line. |
| • | Basis: Select the value at which a basis line should be drawn, if applicable. You can also select the color to be used to draw the basis line. |
| • | Lwr Ref: Select the value at which a lower reference line should be drawn, if applicable. You can also select the color to be used to draw the reference line. |
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.
Fill Chart 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: