Hello,
If someone is up for a challenge, I would greatly appreciate some help with the VBA for a macro I'm working on. The macro would automatically update the chart's Data Sources for both the Legend Entries and Horizontal (Category) Axis Label i.e. date on the 'Instock Trending Charts' tab as each week a new set of columns and rows are populated in the 'data' tab. The difficulty is the charts in black are a 1 year outlooks {January-January} and the white charts are a week outlook {March Week 1-April Week 1} this would save a tremendous amount of manual labor.
If someone is up for a challenge, I would greatly appreciate some help with the VBA for a macro I'm working on. The macro would automatically update the chart's Data Sources for both the Legend Entries and Horizontal (Category) Axis Label i.e. date on the 'Instock Trending Charts' tab as each week a new set of columns and rows are populated in the 'data' tab. The difficulty is the charts in black are a 1 year outlooks {January-January} and the white charts are a week outlook {March Week 1-April Week 1} this would save a tremendous amount of manual labor.