use formula to dynamically change chart range

[pau1]

Good Evening,

Id really appreciate your help with a problem,

Im trying to dynamicly change a chart range, so it only shows the last six weeks of data, based on a weeknumber within a table range.

In effect i want the a start range for an axis to be:

Please Login or Register  to view this content.

by:

Please Login or Register  to view this content.

using the same concept to indirect against collum Y for the seccond axis

I've tried adding in in via the chart data range that was

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Id really appreciate you help getting this to work,

Kindest Regards,

Paul

[pau1]

Does my question make sense or have I badly explained it?

[MrShorty]

If I understand what you have tried (nesting INDIRECT() inside of the so-called SERIES() function in the chart), this does not work. What you need to do is use your INDIRECT() function to define a dynamic named range, then use the named range to define the series.

Most tutorials use the OFFSET() function rather than the INDIRECT() function, but the overall principle is the same. Review this tutorial to see how they do it: https://chandoo.org/wp/dynamic-chart-data-series/