I have a chart that is based off of some calculations based on the week number. Each week, I have the data brought into the spreadsheet but I can't figure out a way to dynamically update the chart. If I have the chart formula for all 52 weeks, it's normal until the first future week - it goes to 0. Each week, I must manually update the rows that the chart reflects.
There MUST be a way to dynamically reflect only the weeks covered... Any suggestions?
There MUST be a way to dynamically reflect only the weeks covered... Any suggestions?