Hello, We are using POI to update data on the first Excel sheet. The second sheet contains charts that are based on data on the first sheet.
How can we define the chart data range so that it expands or shrinks to hold all the data on the first sheet after we update it using POI? We tried using dynamic ranges and tables but Excel does not change them dynamically after we programmatically change data on the first sheet. Thanks, Alec --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
