Dim a, b
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Dim xlChart As Excel.Chart
Set xlApp = New Excel.Application
Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets(1)
xlApp.Visible = True
a = UBound(Me.MSChart1.ChartData, 1) + 1
b = UBound(Me.MSChart1.ChartData, 2) + 1
xlSheet.Range(xlSheet.Cells(1, 1), xlSheet.Cells(a, b)) = Me.MSChart1.ChartData
Set xlChart = xlBook.Charts.Add
With xlChart
.ChartType = xlPie
.SetSourceData Source:=xlSheet.Range(xlSheet.Cells(1, 1), xlSheet.Cells(a, b)), PlotBy:=xlColumns
.Location Where:=xlLocationAsNewSheet
End With