Can I create two charts from the same table?

[Deleted user]

I am trying to create two different charts based off the same table. Short of recreating the table, is there another way of creating the second chart?

[Bob Swift · Accepted solution]

Put the table on a separate page. Then use include page macro inside the various chart macros.

Here is the storage view of the page:

<ac:structured-macro ac:name="chart"><ac:parameter ac:name="dataOrientation">vertical</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:name="include"><ac:parameter ac:name=""><ac:link><ri:page ri:content-title="chart include" /></ac:link></ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro>

[Deleted user]

i tried that and it didn't work, any other suggestions?

[Bob Swift]

It does work. Double check your pages.

[Deleted user]

It does work, Out of how is this different from copying and pasting the table twice?

[Bob Swift]

It makes it possible to only have one copy of the table so that when it gets updated, both charts will reflect the same update.

[Sandeep Sharma]

This worked for me as well but did not solve the purpose. It allows only 1 chart from a table. This is what I intend to achieve

1. Create single table on "Page 1" 

2. Create 3 different charts on "Page 2" using the same table on "Page 1"

3. I am able to create 1st chart by including "Page 1" but as soon as I try 2nd chart, the 1st page include vanishes. Looks like it allows one page to be included only once.

Is there a way I can include a section (table in this case) from Page 1 multiple times on Page 2 for creating different charts?

Please suggest.

[Katerina Kovriga {Stiltsoft}]

Hi @Sandeep_Sharma ,

We can suggest using our app - Table Filter and Charts for Confluence. It's available for Cloud/Server/Data Center.

This case is a common one for the app: you reuse your source table as many times as you need with the help of the Table Excerpt/Table Excerpt Include macros (on the same page or other pages).

Then you wrap each Table Excerpt Include macro in the Chart from Table macro and create different charts based on the same table. So, you'll get a kind of a dashboard.

[Sandeep Sharma]

Thanks Katerina!

I am yet to try this in full but read through the documentation and it should help me fulfill my requirement.