Charts from Spreadsheet

Jhonatan Lozano

Hi

I have a "table spreadsheet" merged in an "Advanced Tables - Tables plus" macro. In this spreadsheet I've built some tables that use formulas to update each column after an user insert some data. Well, what I want to do is to generate a chart from this data, however I don't want this chart to appear inside the spreadsheet but outside of this. In other words, how can I to update a chart from a spreadsheet?

It would be very useful your commentaries.

Stiltsoft support

Hi @Jhonatan Lozano ,

The Table Spreadsheet macro belongs to our Table Filter, Charts & Spreadsheets for Confluence app.

The "Advanced Tables - Tables plus" macro is not ours and belongs to some other vendor. Not sure how it works and why you use it along with the Table Spreadsheet macro. So, here I can talk only about our macros.

If you want to build a graph or several graphs based on the spreadsheet, you may use the Table Spreadsheet Include macro. With the help of this macro you'll be able to reuse cell ranges from your Table Spreadsheet macro.

Then you'll be able to wrap your Table Spreadsheet Include macro in the Chart from Table macro and create your graph outside of the spreadsheet like you want.