Use wildcard for Values Column

Question

I am using a 'Table from CSV' macro wrapped by  'Chart From Table' macro to create a stacked column chart.

In the  'Chart From Table' configuration I need to update the Values column field.

The problem is that my data may change and providing hardcoded Values Column may not be correct  - show partial data or miss other data that exists in the excel file.

Is there a way to configure the Values column with a wildcard? Something like:

If not, what are my alternatives?

Katerina Kovriga {Stiltsoft} · Answer

Hi there,

As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit modes. The Table Spreadsheet macro is available for Cloud and Server/Data Center.

Eyal Zmora · Answer

The columns are semi random...

I will wait for your implementation.

Thanks

Katerina Kovriga {Stiltsoft} · Answer

The Chart from Table macro will check all the typed in headers: if there are any then they will be included into the graph. So, if you know all the possible variants, then just type them beforehand.

If your columns have random unpredictable names, then there is nothing to be done at the moment.