..2 Form

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.

 

Create a Form structure

Add the new components into form structure as shown in the picture below:

Form structure tree


Context binding for components


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


Context binding SAP Excel Chart


 

Markup of template

Markup an Excel-template as shown below :


MS Excel Chart ABAP SAP



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:


Excel Template binding SAP Chart



 

«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:

SAP Excel Grid


 

«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:

Advertizing


 

«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:

Sales




Activate the Form by pressing a button 

Form is ready to use.