Publish charts as PNG

[avi]

Hello,

The Publish process from Excel to Web transforms charts to Gif files,
resulting in poor resolution quality.

Is it possible to improve the quality by transforming to other
pictures types or by any other means?

Thanks
Avi

 

[Gord Dibben]

You can save a chart as *.png before posting that *.png only to Web

But I don't know how to do this through>Button>Publish

Sub SaveAspng()
' Saves the active chart as a png file
' Prompts for a file name and directory
Dim FileName As Variant
If ActiveChart Is Nothing Then
MsgBox "Select a chart to export."
Else
FileName = Application.GetSaveAsFilename( _
InitialFileName:=ActiveChart.Name & ".png", _
FileFilter:="png Files (*.png), *.png", _
Title:="Save chart as png file")
If FileName <> False Then ActiveChart.Export FileName, "png"
End If
End Sub


Gord Dibben MS Excel MVP

 

[Jon Peltier]

At the end of this tutorial I have a link to a free add-in you can use
to export charts in whatever format you like, though PNG is best.

Enhanced Export Chart Procedure | PTS Blog
http://peltiertech.com/WordPress/enhanced-export-chart-procedure/

- Jon