You can use any field or function in an Impromptu report as an input parameter to a Charts Unlimited macro.
- Add the report field or function that you want to use with a macro to the end of "Primary Axis" list in the Data tab of the Chart Properties dialog.
- Make a note of the zero-based position of this field in the "Primary Axis" list.
- In your Charts Unlimited macro, use the letter "P" followed by the number that represents the position in the "Primary Axis" list.
IMPORTANT NOTES:
- Do not reference an item in the "Primary Axis" list that is part of the dataset being graphed (i.e., do not use "P0"). This would cause that particular data series to disappear.
- You cannot use the same "P" parameter twice (e.g., @CXY 0 1 P5 P5 is not valid).
- Currently, only NUMERIC (integers, Booleans, reals) parameters can be mapped. Charts Unlimited does not currently support runtime mapping of string parameters.
EXAMPLE:
In the Data tab of the Chart Properties dialog, the "Sale Margin" field is added at zero-based position 1 in the "Primary Axis" list.
The following macro will create a line on the Y1-axis at the value of "Sale Margin".
@Y P1
Return to General Usage Notes
Next to Macros
Return to Main Page
