How to combine the macros

• Combining of Table Excerpt/Table Excerpt Include with Table Filter

Table Filter & Chart from Table

1. Create a table or add the macro outputting the table data or include the excerpted table with data values.
2. Insert the Table filter macro and place the table (the macro outputting the table data or the Table Excerpt Include macro) within the macro.
3. Add the filters and configure the filtration parameters.
4. Insert the Chart from Table macro.
5. Place the Table filter macro with the table inside the Chart from Table macro.
6. Configure the parameters of the chart.
7. Save the page.
8. Change the filtration criteria. Filtration will be automatically applied to the data table and the chart will be automatically updated.

9. Change the chart parameters if needed.

Table Filter & Pivot Table

1. Create a table or add the macro outputting the table data or include the excerpted table with data values.
2. Insert the Table filter macro and place the table (the macro outputting the table data or the Table Excerpt Include macro) within the macro.
3. Add the filters and configure the filtration parameters.
4. Insert the Pivot Table macro.
5. Place the Table filter macro with the table inside the Pivot Table macro.
6. Configure the parameters of the pivot table.
7. Save the page.
8. Change the filtration criteria. Filtration will be automatically applied to the data table and the pivot table will be automatically updated.
9. Change the pivot table parameters if needed.

Table Filter & Pivot Table & Chart from Table

1. Create a table or add the macro outputting the table data or include the excerpted table with data values.
2. Insert the Table filter macro and place the table (the macro outputting the table data or the Table Excerpt Include macro) within the macro.
3. Add the filters and configure the filtration parameters.
4. Insert the Pivot Table macro.
5. Place the Table filter macro with the table inside the Pivot Table macro.
6. Configure the parameters of the pivot table.
7. Insert the Chart from Table macro.
8. Place the Pivot Table macro inside the Chart from Table macro.
9. Configure the parameters of the chart.
10. Save the page.
11. Change the filtration criteria and the pivot table parameters. The chart will be automatically updated.
12. Change the chart parameters if needed.