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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Access Combination Chart Types Access 2010 0
add a chart in a Add-In 1
getting the active chart/chartobject's name 4
selecting graph 2
Copying excel charts to word through VBA 0
not showing blank cells in a chart 2
dynamically increase x axis 5

Back
Top