Skip to end of metadata
Go to start of metadata

Intro

Any chart that references a range with data markers will have its data source updated when ExcelTemplate imports rows of data. Make changes to a template without making any changes to code.

Open the template, right click on the chart and choose the "Select Data..." option.  This will open a window with details about the charts data range.  Though the range for the chart is only one row (=ChartSheet!$A$26:$B$26), will update the data formula when the data is bound to the data markers in the cells.   

A populated version of the chart is available for download below.

Code

Downloads

  • No labels