I am trying to create a pie chart for various numbers of cells. For example, the first time I have a cell range of A2:A10, the next time the spreadsheet is used the cell range is A2:A33. I want to select all possible ranges of cells, let's say 49 (A2:A50). Now if as in my first example only cells A2-A10 have values, I want my pie chart to ignore cells A11-A50, because they are empty, and not have any reference to them. Is this possible? If so, how?

thanks, Chester