But to expand the size of the range, by adding rows and columns, and change the chart's data and appearance, you must manually change the original data source in the chart by changing the cell range that a chart is based on.
If you want to change the chart's data and appearance when the data source expands, you can use an Excel table as the underlying data source.
You can automatically update changed worksheet values in a chart, or you can use ways to dynamically change a chart's underlying data source.
The values in a chart are linked to the worksheet data from which the chart is created.
The customer had over 50 Terms they needed to setup. When you create the source file, you will need a column for each field you will be importing. Open the file with Microsoft Office Word, go to the Mailings tab, select Start Mail Merge and from the drop down menu select the Step-by-Step Mail Merge Wizard.
Please contact us ([email protected]) if you need assistance creating a Macro, or using the Word Mail Merge for this or any other entry process when trying to add or modify several records from a source file.
The chart must be on the same worksheet as the data that you used to create the chart.
You can use one of several ways to include additional source data in an existing chart.
Another approach to dynamically changing the chart's data and appearance when the data source expands is to use a defined name with the OFFSET function.