Updating excel graph

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.When the source data for your data-driven charts is available in Excel, you can create charts directly from the Excel application.When data in Excel changes, you can either update the charts on command or have think-cell do the update automatically.

For instance, you may have some data that represents a time period, such as 11/1 through 11/13, and you create a chart based on those dates.You probably arrived at this page because you are a business professional who has to present regularly to management or executives on analysis you have done in Excel.You don’t want to have to retype a table of numbers or recreate a graph in Power Point.We all know that to make a chart we must specify a range of values as input.But what if our range is dynamic and keeps on growing or shrinking.