View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ben McClave Ben McClave is offline
external usenet poster
 
Posts: 173
Default How I can set dynamic pivot table ONLY when I have enough data point

Vincent,

This is a simple solution, but might work for you. Place an image over the chart such that the chart can't be seen (image could be a simple white background or even a message such as "Not enough data").

Then, place this code in the worksheet's Change event:

Private Sub Worksheet_Change(ByVal Target As Range)

Sheet1.Shapes("Image1").Visible = WorksheetFunction.CountA(Range("$A$2:$A$23")) < 13

End Sub