Blank Cells
 

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

Blank Cells
 

Limit the chart to the points that have data. As each month passes, extend
the range of the chart.
--
Gary''s Student - gsnu200805


"tmusur" wrote:

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

Blank Cells
 

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,
--
T


"Gary''s Student" wrote:

Limit the chart to the points that have data. As each month passes, extend
the range of the chart.
--
Gary''s Student - gsnu200805


"tmusur" wrote:

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