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

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

--
Jon Quixle
-----------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...fo&userid=2580
View this thread: http://www.excelforum.com/showthread.php?threadid=46779

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.

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?

"Blue Aardvark" wrote:

> 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.

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

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

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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Does this help

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


--
Don Guillett
SalesAid Software
(E-Mail Removed)
"bongoman" <(E-Mail Removed)> wrote in message
news:65F6FA70-6771-4022-8B9A-(E-Mail Removed)...
> Does anyone know if it is possible to export an Excel generated
chart/graph
> as a .jpg or .gif into a webpage?

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/
_______


Debra Dalgleish wrote:

> Andy Pope has a free add-in that you can use to export images or charts:
>
> http://www.andypope.info/vba/gex.htm
>
> bongoman wrote:
>
>> Does anyone know if it is possible to export an Excel generated
>> chart/graph as a .jpg or .gif into a webpage?
>
>
>

"bongoman" wrote:

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

You can use VBA code to export a chart.

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

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"maryla" <(E-Mail Removed)> wrote in message
news:112EDC4E-81EE-4567-9BE4-(E-Mail Removed)...
>
>
> "bongoman" wrote:
>
>> Does anyone know if it is possible to export an Excel generated
>> chart/graph
>> as a .jpg or .gif into a webpage?