How to create a chart with SQL

Summary

The Chart macro combined with the SQL macro provides powerful visual reporting capabilities. These macros were designed to work together. The SQL macros produce standard Confluence tables. The Chart macro produces charts from tables included in its macro body. Of course, the parameters of the Chart macro must define a chart that can be produced from the format of the table (or tables) included in the chart macro body. So part of the challenge is to define the chart correctly to match with your table(s) produced by the SQL macros and this depends on what you are trying to do and how you have constructed the SQL. The Chart macro has a number of parameters that can be adjusted to accommodate different table arrangements. This article explains some simple examples to get started. 

Steps


ProductRevenue
A234,300
B346,212
C224,564