Excel Annual Graph - Is It Possible Not To Chart Future Weeks

[PWD]

Good morning. Just an "I don't like the look of this" moment. Is it possible not to have the chart nosedive when it passes the last week with values? The Data Source is $D$8:$BC$ so that it will expand when new data is added. The fomula in these cells is =IFERROR(((M6-M7)/M6),"")

Just a thought.

Many thanks,
D€$

 

[SkipVought]

Hi,

Hide future weeks via auto filter.

 

[PWD]

Hi Skip, I'm probably being thick but if I hide (filter) the rows that are blank then the previous columns (with data) are also hidden.

Many thanks,
D€$

 

[SkipVought]

Then you are not using the correct column OR the data is structured incorrectly!