I am struggling with creating a chart that will automatically update it's range in excel. I have tried several solutions (defining names, using a table, etc.) but I run in to the same problem every time. The point is for the data to be copy pasted in to the correct month on the "master" worksheet and have it automatically update the charts for all of the stores. The problem with the dynamic charts I have tried so far is they include all of the blank cells as they are not truly blank (they have formulas to find the data from the master tab). I need to either find a way to have the chart ignore those cells until they are filled with actual numbers, or use a macro that will add the next row of data to each chart.
Thank you so much for your help,