I have created some name ranges for X and Y Values in order to update a chart automatically.
The problem I have is that the Name Range for the Y Value is including blank cells in Column F, G, H. I am needing to change the Name Range for the YValue to only extend as far as there is data in row 3. So as new data is enter in row 3 the range would extend.
I have included my spreadsheet for review.
Bookmarks