New Chart Types
Public Function Chart_TypeIdentify_New2016(ByVal oChart As Excel.Chart) As Boolean
Const sProcName As String = "Chart_TypeIdentify_New2016"
On Error GoTo ErrorHandler
Chart_TypeIdentify_New2016 = False
If ((oChart.ChartType = xlBoxwhisker) Or _
(oChart.ChartType = xlHistogram) Or )
(oChart.ChartType = xlPareto) Or _
(oChart.ChartType = xlSunburst) Or _
(oChart.ChartType = xlTreemap) Or _
(oChart.ChartType = xlWaterfall)) Then
End If
Exit Function
ErrorHandler:
Call Error_Handle(msMODULENAME, sProcName, Err.Number, Err.Description)
End Function
This line causes Excel to crash for a TreeMap
ActiveChart.Legend.Font.Size = 8
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext