Automatically changing named ranges can save you time, avoiding the need to manually change the chart data range as new data is added, for example, for monthly reports.  The key to this is using the OFFSET function when defining the name. Continue reading →