Can I export a chart from Excel as a jpg or gif?

[bongoman]

Does anyone know if it is possible to export an Excel generated chart/graph
as a .jpg or .gif into a webpage?

 

[Jon Quixley]

There is, but it involves another program (Paintshop Pro or somethin
like it).

Have Paintshop Pro open before you start

Select the chart and with the SHIFT key depressed, go to EDIT and COP
PICTURE. You will be given the option of saving the picture as a BM
file - do this and paste the picture into Paintshop Pro. Save it as
*.jpg before moving this into your web page

Jo

 

[Blue Aardvark]

You can select the chart. Copy it. Then do a paste special in programs like
Word. If your web design program doesn't have a paste special option, you can
always paste it into word and then copy the pictures out.

 

[bongoman]

Many thanks for your help. The thing is i need a non-techy person to be able
to be able to export the chart to a Content Management System so that they
can publish it to a web page themselves, without having to use a web-design
programme. Any ideas?

 

[Debra Dalgleish]

Andy Pope has a free add-in that you can use to export images or charts:

http://www.andypope.info/vba/gex.htm

 

[Don Guillett]

Does this help

Sub ExportChartJPG()
ActiveChart.Export Filename:="C:\a\MyChart.jpg", _
FilterName:="jpeg"
End Sub

 

[Jon Peltier]

John Walkenbach's Chart Tools also does this (http://j-walk.com).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[maryla]

Does anyone know if it is possible to export an Excel generated chart/graph
as a .jpg or .gif into a webpage?

 

[Andy Pope]

You can use VBA code to export a chart.

ActiveChart.Export _
FileName:="current_sales.gif", FilterName:="GIF"

Cheers
Andy

 

[Don Guillett]

Sub ExportChartJPG()
ActiveChart.Export Filename:="C:\a\MyChart.jpg", _
FilterName:="jpeg"
End Sub

 

[Tushar Mehta]

If you don't want to use code as has been suggested by others, select the
chart, then select File | Save as web page... In the resulting dialog box,
select the option for 'Selection (chart)'. Save the file using the default
name (Page.htm) somewhere, say My Documents. Open My Documents and open the
folder Page_files. You'll find the chart in there as a gif.

Alternatively, copy the chart, switch to a program that supports image
export (such as an image editor or even PowerPoint) and paste. Now, save
that object as an image file. In PP, right click the image and select 'Save
as Picture...'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions