The Form's source is here .

How to import Form into the system see here .

Create and save a new form

Launch an XLSX Workbench, and create a new form with name CHART_COMP .

Assign a context to the form 

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.

Context binding for components

Perform Context binding for «Loopstep» , «Value» and «Grid» according to scheme below:

Markup of template

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 :

Template binding for components

Perform Template binding for all the «Patterns» and the «Value» according to scheme below:

«Grid» of the Dataset

Select the «Grid» component node in the Form structure tree, and make some settings in the Properties tab according to scheme below:

«Chart» for the Advertizing budget

Select the «Chart» component node in the Form structure tree, and make some settings in the Properties tab according to scheme below:

«Chart» for the Sales

Select the «Chart» component node in the Form structure tree, and make some settings in the Properties tab according to scheme below:

Activate the Form by pressing a button