Launch an XLSX Workbench, and create a new form with name CHART_COMP .
Assign a context ZCONTEXT_CHART_COMP to the form. When an automatically creation of the Form structure will be prompted, you should press the button
to create a structure manually.
Add the new components into form structure as shown in the picture below:
Perform Context binding for «Loopstep» , «Value» and «Grid» according to scheme below:
Markup an Excel-template as shown below :
Note: To create both charts we use the Dummy (temporary) dataset .
So, select the Dummy dataset sell range, after that, go to menu Excel: Insert--> Chart and pick a chart that you need :
Perform Template binding for all the «Patterns» and the «Value» according to scheme below:
Select the «Grid» component node in the Form structure tree, and make some settings in the Properties tab according to scheme below:
Select the «Chart» component node in the Form structure tree, and make some settings in the Properties tab according to scheme below:
Select the «Chart» component node in the Form structure tree, and make some settings in the Properties tab according to scheme below:
Form is ready to use now.