I have seen examples of how to do expanding and contracting dynamic ranges for charts based on a data table. What I would like to know is if you can establish a dynamic range when you are doing your chart from a pivot table. I want to do this so there is not a blank space in the bar chart when I filter (because some selections result in more categories of data than others. I can post an example, but just wanted to get a sence of whether this is possible. Thank you for some input on this.