| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum to a mid point in a dynamic table | Excel Discussion (Misc queries) | |||
| Source data for pivot table to point to cell on worksheet? | Excel Programming | |||
| vlookup data in a dynamic pivot table? | Excel Worksheet Functions | |||
| pivot table with dynamic base data | Charts and Charting in Excel | |||
| Pivot Table & Dynamic data | Excel Programming | |||
Threaded Mode
