For a step-by-step guide on how to create a chart from your Excel data using think-cell, please consider the example from Introduction to charting.
This is how the example chart data looks in Excel: To create a chart from Excel, select the desired data range in your Excel workbook, including series and category labels: The layout of your data must match the layout of think-cell’s internal datasheet: Column charts are usually created from data columns, whereas bar charts are created from data rows.
If it is possible that the objects don't fit into memory, then the data type CLOB (for textual data) or BLOB (for binary data) should be used.
Object Linking and Embedding (OLE) is a widely used Microsoft technology that enables objects in two applications to be hot-linked, so that changes to the object in one application cause the same changes in the other application.For example, if you use OLE to link an array in Analytica to a table in a Microsoft Excel spreadsheet, any change to the array in the Analytica model automatically updates the table in the spreadsheet immediately, or the next time you open the spreadsheet.Nevertheless it is possible to transpose the data source (see Transposing linked data).In addition to the data, some cells to the left and on top are reserved for category and series labels.For result tables with more than two dimensions, you can link the entire table as a series of two-dimensional tables using the Copy Table option from the Edit menu.
You can also link a rectangular region of cells that are a subset of a two-dimensional table.To unlock a data link, click Locking on the Table ribbon contextual tab., a master table is a standalone table that is linked to by one or more linked tables (Figure 1).By default, a data link is locked from editing to prevent undesired changes to the linked spreadsheet.You can lock cells from data changes, format changes, or both.This can be done using is used, the sorting is done using an external sort algorithm.