Is it possible to export a Graph to a Gif formatted file in Office at Mac

I intend to make a lot of complicated graphs in an Excel workbook at my Mac. As I earlier understood that Excel has a rather limited capacity for graphs in one workbook, I coded the Export method of VBA in a Sub for converting graphs into .GIF files.

When I applied this sub, as attached, to convert a graph, it gave no .GIF output file, whereas I checked that the FileName was correct.

After that, I also tried the same Sub with Export format .PNG, which is the standard Export method at Mac, but this also did not give any output and also no error message.

I understood that the relevant Graphics Export Filters have to be installed inOffice, but I do not know how to check that, neither if these Graphic Export Filters are available for Office 365 at Mac.

Any suggestions?

Sub SaveActiveChartAsGif()

' Export active graph to file Thisworkbook.Path & "\" & ActiveChart.Name & ".GIF"

Dim Fname As String

Dim FileName As String

Dim ansmsg As Integer

If ActiveChart Is Nothing Then

ansmsg = MsgBox("No actieve graph: no file will be exported", vbOKOnly)

Exit Sub

End If

Fname = ThisWorkbook.Path & "\" & ActiveChart.Name & ".GIF"

ansmsg = MsgBox("Full name of exported file = " & Fname, vbOKOnly)

ActiveChart.Export FileName = Fname, Filtername:="GIF"

ansmsg = MsgBox("FileNaam = " & FileName, vbOKOnly)

End Sub