Hi All,
I have what is probably a simple problem but can't see a quick fix.
I have a number of charts that feed of data in other tabs. The top row of the data tabs represent dates. Periodically I need to update these sheets and have some VBA code that does this. When the update runs, part of the process loops through the date headers and inserts columns where data values are missing from the series sequence.
The problem occurs because the inserted columns become an explicit part of the charts' data ranges. i.e. if the data range covered columns A through E, inserting a between B and C forces the data range to become A:F. I guess I could go into the charts data range parameters and redefine them, but I wondered if the is an easy way fix the chart's data range in an absolute sense.
Hope this makes sense. Thanks.
Rob
I have what is probably a simple problem but can't see a quick fix.
I have a number of charts that feed of data in other tabs. The top row of the data tabs represent dates. Periodically I need to update these sheets and have some VBA code that does this. When the update runs, part of the process loops through the date headers and inserts columns where data values are missing from the series sequence.
The problem occurs because the inserted columns become an explicit part of the charts' data ranges. i.e. if the data range covered columns A through E, inserting a between B and C forces the data range to become A:F. I guess I could go into the charts data range parameters and redefine them, but I wondered if the is an easy way fix the chart's data range in an absolute sense.
Hope this makes sense. Thanks.
Rob