Thread: Resolved >>> Moving histogram

Hello.

Every month, I produce a set of about 15 stacked histograms charting changes in a given set of categories. Right now, there's no problem - I just fill in the data for the current month and publish the charts. However, I want this histogram to start shifting once we get to December (so in March 2008, the chart will start at March 2007, not January).

As far as I can see, this will entail the manual adjustment of every chart's data range, every month (i.e. shifting it one column to the right). Is there any automatic trickery (say, using the today() statement) that can save me from this RSI/clinical depression hell?

I'd be ever so grateful for some help. I'm probably missing something very obvious!

EDIT: I'm running Excel 2003 on XP.

Thanks,

Hello Tom,

Welcome to the forum, may be this link has the answer for you?

http://peltiertech.com/Excel/Charts/DynamicLast12.html

oldchippy,

Thanks a bunch! This really helped. I had to fiddle around a bit transposing the formulae (my data needs to grow in rows rather than columns), but that done, it's starting to look great.

I'm spending a low of time now creating new named ranges for each of the charts I need to create (15 charts x 7 ranges = 105 -- !) and changing the references for each and every chart, but I guess I'll just have to deal with that...

Thanks again,

Glad you found the answer you wanted Tom - thanks for the feedback