Idea on how to create a chart of a part of a (not the entire) table?

[Markus Raab]

I'd like to have one source table but I want to create several charts out of this one table. I learned that this is possible if the source table is put on it's separate page, and the table is included several times on other page(s). 

With this attempt I can reuse one single source multiple times, to create multiple charts.

Anyway, I'd like to create such charts from a filtered table and not always from the entire table?

This is specifically interesting if I want to re-use some rows in several charts.

Do you have any idea how to do that?

best regards

Markus

[Andrey Khaneev _StiltSoft_ · Accepted solution]

Hello Markus,

Table Excerpt + Table Excerpt Include macros allow you to reuse the source table on the page several times without its duplication on the page, so this works faster then native Excerpt Include macro.

But filtering Table Excerpt Include filters the source table, so each Table Excerpt Include referencing this table will reference filtered table.

In case you need to use different filtered table representation, you have to you Excerpt Include macros. In case you need to reuse the same representation of the table on a page, it is better to use Table Excerpt Include macros.

Also there can be another workaround: use Table Excerpt Include macros, wrap them with Pivot Table macro and then filter it with Table Filter macro and create a chart with Chart from Table macro. In this case only pivot table will be filtered and the source table can be reused again. But you need to check whether this solution will work in your case.