Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,364,059
Community Members
 
Community Events
168
Community Groups

Multiple charts from table

Edited

Given an existing table in a confluence document with non numerical data, is it possible to generate multiple charts from the same table? I tried using the chart from table macro, but it requires a table pasted within each individual macro. Is there a way to paste a table reference so that I can edit the data in one centralized location without having to paste the table in each macro? 

I have attempted to use the table visualization feature built into the table macro, but my data is non numerical and does not compile. I don't think there's a way to make this work if my data is not numbers based, but please let me know if I'm wrong here. 

 

 

1 answer

1 accepted

4 votes
Answer accepted

Found a workaround nesting a table excerpt inside a pivot table inside a chart from table macro. 

Hi @Nate Dickinson ,

I think I'm late due to the time zone difference, but wanted to note that your approach is right.

To create several aggregated/visualized views of the same table, wrap it in the Table Excerpt macro and then reuse it as many times as you need via the Table Excerpt Include macros.

These Includes can be further wrapped into other our macros and serve as independent sources.

Thus you'll receive a kind of a dashboard: make changes to the original table inside the Table Excerpt macro, the updates will be passed to the Table Excerpt Include macros and your pivots/charts will be also updated.

Like # people like this

Thank you for the reply. I actually found documentation from stillsoft that helped me find a resolution to the function I was trying to produce. The solution I have is this: 

  1. Put the relevant data into a table excerpt macro and name it something 
  2. Add a table excerpt includes macro and reference the original table excerpt within the new includes macro 
  3. Nest the excerpt includes macro inside a pivot table macro 
  4. Nest the pivot table inside a chart from table macro 
  5. Chart what is required 
  6. Copy the nested macro and change parameters to make other charts
Like # people like this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS

Atlassian Community Events