Excel cannot directly export charts or
Save As in other image formats,
but with a simple macro one can export charts in
This format is great for including charts in LaTeX documents
The macro can be stored in the personal macro file
Excel 2010 places the file in the following location:
This file is hidden when first starting Excel. To unhide, perform the following steps.
+ View -> Unhide + Unhide personal macros file.
You can now select the
View -> Macro or the
Developer -> Macros menu items to create a new macro.
The macro for saving the generated
PNG files is as follows:
Sub Export_ActiveChart_as_PNG() ' ' Export_ActiveChart_as_PNG Macro ' Export Active Chart as PNG ' ActiveChart.Export Filename:="C:\path\to\save\excelcharts\" & ActiveSheet.Name & ".png", Filtername:="PNG" End Sub
PNG file can now be used in
tex documents as usual.
Today, however, I found another alternative, but it doesn't work as well.
Save chart as
Excel 2010 provides a
Save As option that can save the active chart as a
but the resulting
PNG route works better, in my opinion.