The Charts macro is supposed to work with Play SQL. However, since a recent Confluence release, it is impossible to preview the Charts macro. However, previewing and saving the page work.
First preview the Play SQL macro,
Copy-paste the static data table into the Charts macro,
Design your chart and preview it at will,
Then place the query macro back into the Charts macro.
Blocked by: CONF-33581