You can create a dashboard with multiple charts and pivot tables based on one Jira Issues macro with the helsp of theĀ Table Excerpt and Table Excerpt Include macros.
The following options are useful for better viewing:
Hide filtration panel (Tabel Filter)
Hide control panel (Pivot Table)
Hide chart controls (Chart from Table)
Show/hide source table (in Table filter, Pivot Table, Chart from Table)
Set chart dimensions
Align a chart
Chart legend position
Set colors and line settings
Create a user macro to hide the unnecessary information from the Jira Issues macro: