How do you create a pie chart using the status macro

Question

How do I create a PIE chart using the status macro in a column.

For example, if I have a chart of all my projects listed and one of the column called "RED/YELLOW/Green" where I use the status macro, how do I display that in a PIE chart?  If I have a total of 10 projects, where 5 of them are green, 2 of them are red, and 3 are yellow, can I create a pie chart? Is there a count feature to count the number of red/yellow/green status macros?

Thanks,

amy

Katerina Kovriga _Stiltsoft_ · Answer

Hi @Elma Lam ,

If you can't find the Pivot Table, Table Filter, Table Spreadsheet macros in your macrobrowser, it means that the Table Filter and Charts for Confluence app is not installed for your instance.

It is a paid add-on that should be installed from the Atlassian Marketplace by your Confluence administrator.

Elma Lam · Answer

I cannot find "Pivot Table" from my confluence, do you have any idea?

I tried to browse and search but no result found, Thanks a lot!

Andrey Khaneev _StiltSoft_ · Answer

Hello Amy,

You can use combination of Pivot Table and Chart from Table macros (Table Filter and Charts add-on) to build the chart. Something similar you can see in this video.