How does Think-Cell read columns and rows from Excel?
Answered on : 2024-07-11
Sources
Answer
Think-Cell is a powerful charting software that integrates with Microsoft PowerPoint and Excel to create complex charts and visualizations. When working with Think-Cell, the way it reads columns and rows from Excel depends on the type of chart you are creating.
For bar charts, Think-Cell reads columns as individual series of data. This means that each column in your Excel datasheet represents a different series that will be displayed as a separate bar in the chart [1]. Conversely, in column charts, rows typically represent the series, and the columns contain the data points for each category within the series [4].
When you want to link your Think-Cell chart to an Excel data range, you would select the green border of the data range in Excel, right-click it to open the context menu, and choose "Transpose Link" if necessary. This option is useful if you want to switch the axes and read rows as columns or vice versa [2].
To create or update charts with Think-Cell, you start by selecting the required chart type from the Think-Cell group in PowerPoint. Then, switching to Excel, you select your data and click the appropriate options in the Think-Cell menu to insert your chart, such as Elements -> Line for a line chart [3][6].
For Gantt charts and other complex visualizations, Think-Cell offers additional functionalities like adding extra rows or deleting them, which can be accessed through specific keyboard shortcuts or context menu options [7].
In summary, Think-Cell reads data from Excel based on the chart type you are creating, and it offers flexibility in linking data ranges and transposing rows and columns to fit your visualization needs.
Related
· Ask and AnswerGlarity
Don’t worry, a human is here to help you!