I have a chart that list a line graph for each month. The problem I am
having is that since I don't have data for the other half of the year the
graph will drop down to 0. I could just modify the range but I am trying to
automate this chart. I was wondering if there is a macro that will delete
blank cells in a range even if they have GETPIVOT function but does not
return any value?

--
T