The Formula tab is the second tab in
the Data Builder. MIMIC represents a formula in the Worksheet with the
Formula
icon.
The Formula tab in the Data Builder includes the following options:
| Option | Function/Description |
|---|---|
|
Allows users to create a formula from the labels representing each series. A formula is written in algebra using the basic operators: +, -, *, and /. For example, to subtract row 'B' from row 'A' (or A – B). | |
|
Indicates the description of the formula. The description displays in the legend for the chart and under the Column heading for the table. | |
|
Displays the results of the selected row in a table. | |
|
Displays the results of the select row in a chart. | |
|
Indicates a line chart, bar chart, or anchor a symbol as a baseline in a chart. The Invisible setting means that MIMIC does not chart the selected row. | |
|
Indicates the chart label displays in the legend of the chart. | |
|
Indicates the number of decimal places that the series will be quoted in. | |
|
Displays the maximum, minimum, average, last or standard deviation in a chart. Checking Apply to All Items applies the selections to any future series. |