Blank Cells

[tmusur]

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?

 

[Gary''s Student]

Limit the chart to the points that have data. As each month passes, extend
the range of the chart.

 

[tmusur]

Thanks for the advice but I am trying to automate the report so I don't have
to manually change the range each month. Anyway, I found a solution when I
set up the getpivotdata function to populate the data for the chart I can put
an IF statement to populate #N/A is there is no data and the chart will
ignore it.

Thanks,