|
ExcelTemplate can be used with Excel charts of all types. If the chart
references a dynamic range of data that is imported by ExcelTemplate, the chart
references are automatically updated by ExcelTemplate without any additional
coding.
Technical Overview
View the template file to see how to properly set up charts in the template
workbook. Open the template and view the chart's Source Data window
(right click on the chart area, select Source Data...). Notice how the
chart reference is a range of data that is just one row, eg,
=ChartSheet!$B$27:$B$27. ExcelTemplate updates the right-hand side of
this data formula reference to fit the data that is imported.
Click below to run the demo, and then observe how the Source Data in the
generated report has been updated. This demo also demonstrates importing
data from a database using the ExcelTemplate setDataSource method.
View source
View template
Click to run demo
Copyright 2005 © SoftArtisans, Inc. All Rights
Reserved.
|
