Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.