Hello,
I try to convert an excel graph in the image and automatically (because I have 140 to do) in a different slide ppt (140 therefore slides at the end).
Could someone help me?
Thank you!
Hello,
I try to convert an excel graph in the image and automatically (because I have 140 to do) in a different slide ppt (140 therefore slides at the end).
Could someone help me?
Thank you!
Pressing shift when you click "Edit" to copy, it offers you to "copy image".
You have generated a chart in an Excel spreadsheet and you want to export as an image. A macro allows you to easily export the GIF graphics format of your choice.
- Open the workbook containing the chart export.
- Open the Developer tab.
- Click the Visual Basic.
- Click on the Insert menu and then click Module.
- Then copy the following lines:
Code:Sub SauveGIF () Fname = ThisWorkbook.Path & "\" & ActiveChart.Name & ".gif" ActiveChart.Export FileName:=Fname, FilterName:="GIF" End Sub- Close the editor window of Visual Basic.
- In your workbook, click on the graph to be exported.
- Click Macros.
- In the window that opens, click the Run button to launch the macro Backup.
- The chart is saved in the folder where your workbook.
Bookmarks