Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Empty Pivot Chart
Is there a quick and easy way of programmatically checking to see if an OLAP
Pivot table or associated chart has no data in it Thanks in advance, Tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Empty Pivot Chart
I use this when printing pivot charts:
If ActiveChart.SeriesCollection(1).Points.Count = "" Then 'do nothing Else ActiveWindow.SelectedSheets.PrintOut End If Tony wrote: Is there a quick and easy way of programmatically checking to see if an OLAP Pivot table or associated chart has no data in it Thanks in advance, Tony -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Empty Pivot Chart
Thank you for that. Unfortunately this doesnt work for me.
I think it becasue there are Dimensions and Series on the chart but my current selections have filtered out all the data e.g. selecting Saturday from a DOW dimension when data only exists for Mon - Friday. I need some indication that my selection criteria does not return any results "Debra Dalgleish" wrote in message ... I use this when printing pivot charts: If ActiveChart.SeriesCollection(1).Points.Count = "" Then 'do nothing Else ActiveWindow.SelectedSheets.PrintOut End If Tony wrote: Is there a quick and easy way of programmatically checking to see if an OLAP Pivot table or associated chart has no data in it Thanks in advance, Tony -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Empty Pivot Chart
Perhaps you could use the GetPivotData function on the worksheet, to
check the total in one of the measures. For example, in a cell named DataCheck: =GETPIVOTDATA("[Measures].[Sum Of Total ]",$A$5) Then, check that cell in the code: Dim rngCheckData As Range Set rngCheckData = ActiveWorkbook.Names("DataCheck").RefersToRange If IsError(rngCheckData.Value) Then MsgBox "No data" Else Sheets("Chart1").PrintPreview End If Tony wrote: Thank you for that. Unfortunately this doesnt work for me. I think it becasue there are Dimensions and Series on the chart but my current selections have filtered out all the data e.g. selecting Saturday from a DOW dimension when data only exists for Mon - Friday. I need some indication that my selection criteria does not return any results "Debra Dalgleish" wrote in message ... I use this when printing pivot charts: If ActiveChart.SeriesCollection(1).Points.Count = "" Then 'do nothing Else ActiveWindow.SelectedSheets.PrintOut End If Tony wrote: Is there a quick and easy way of programmatically checking to see if an OLAP Pivot table or associated chart has no data in it Thanks in advance, Tony -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicating Pivot Chart / Changing Pivot Chart data range | Excel Discussion (Misc queries) | |||
XL2007: Empty pie chart | Charts and Charting in Excel | |||
Chart empty with new data in the dynamic range chart. | Excel Discussion (Misc queries) | |||
empty lines in pivot table | Excel Discussion (Misc queries) | |||
Empty Chart Values | Excel Worksheet Functions |