Blank Cells

  • Thread starter Thread starter tmusur
  • Start date Start date
T

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?
 
Limit the chart to the points that have data. As each month passes, extend
the range of the chart.
 
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,
 
Back
Top