Because the Spreadsheet macro does not render any table in the Confluence editor, it it not possible to visualize a preview of the Chart from the chart macro settings.
As a workaround, if you have trouble configuring the chart, you can:
- create a standard confluence table with the same layout as your Spreadsheet
- use it to configure the chart
- replace it with the Spreadsheet macro.