At the end of each month I prepare a dozen or so rolling graphs some are 2 years and some are 10 years on a variety of items from exchange rates to fuel and electricity prices. But every sheet has the same format dates are in column A (going back as far as we have them in some cases 20 years) one record for each day of the month (some won't include weekends) and values are in column B.
I'm just wanting to know how I can auto update the chart to include either 2 years or 10 years rolling as i currently waste several hours a month doing this and their must be a better way. I've read some items on creating named ranges using offsets but this seems to just increase the size rather then move the graph.
I'm just wanting to know how I can auto update the chart to include either 2 years or 10 years rolling as i currently waste several hours a month doing this and their must be a better way. I've read some items on creating named ranges using offsets but this seems to just increase the size rather then move the graph.
