Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a 'dashboard' of weekly stats - with week numbers in the columns across the top, and about 70 metrics in the rows. I want to create around 20 charts from these different metrics, but always based on the previous 4 weeks.

Can I set up these 20 charts so that it's easy to adjust the range of columns in one go, rather than changing the "Select Data" for each of the 20? I don't want to update the range of 20 charts every week!

share|improve this question

You could use the approach in Chart the Last 12 Months.

Alternatively you could use the add-in (free) described at the end of Change Series Formula to modify the ranges of many charts at once.

share|improve this answer
This looks really promising - if I get it working I'll accept, thanks. – Chris Jun 6 '12 at 21:50

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.