Check out the Step-by-Step tutorial here:
http://www.exceldashboardtemplates.co...
If you don't like the Offset function or don't understand it or don't understand how to use it in charts, then this post is for you. Today you will learn how to create a (mostly) dynamic Excel chart of the last 3 periods WITHOUT using an Offset Function.
If you want to know how to make it truly dynamic with the Offset function, then check out this post:
http://www.exceldashboardtemplates.co...