How to make pie chart for table with categorical columns in confluence ?

[Ross]

I have a table in confluence and I want to have a pie chart like shown in bellow image on that table

How to make something like this ?

[Katerina Kovriga {Stiltsoft}]

Hi @Ross ,

We suggest trying our app - Table Filter and Charts for Confluence.

The first step is to wrap your table into the Table Toolbox macro:

The second step is to create the following nesting: your table <- Pivot macro <- Chart from Table macro.

Then we need to count the number of your text values for the Column A:

And the last step is to make your pie chart based on the pivot table:

If you need to create several different charts for the same table (for Column B, Column C, etc.), we suggest reusing it as many times as you need with the help of the Table Excerpt/Table Excerpt Include macros. 

In such case you'll be able to make changes only to the source table and all of your charts will be updated automatically.

Hope this helps.

[Nicole Griffin]

Hello, is there anyway to do this chart without purchasing an app? This is the most basic type of chart and data requirement; it's difficult to believe this not possible somehow using/manipulating the native chart tool in Confluence.

Many Thanks

[Katerina Kovriga {Stiltsoft}]

Hi @Nicole Griffin ,

The original request was to create a pivot table based on text values and only then to create a chart. The first part is not possible natively.

To create a chart, you may use the standard Chart macro.