Export Chart to jpeg

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

max_dub - 19 Apr 2007 19:49 GMT

I am using MS Excel 2007, and want to export the chart to jpeg file,
but i am not able to locate the functionality, Can anyone give some
clues for it :))

cheers
Mo.

Reply to this Message

max_dub - 19 Apr 2007 20:02 GMT

ok, i copied the chart to Visio and saved it was jpeg :))

mebbe excel shud have that functionality .. anyhow.. problem solved

Reply to this Message

CLR - 19 Apr 2007 22:14 GMT

You're right, it is a function that I also think should be included in
Excel.
For now, I copy and paste into PaintShopPro, and then save as .jpg

Vaya con Dios,
Chuck, CABGx3

> I am using MS Excel 2007, and want to export the chart to jpeg file,
> but i am not able to locate the functionality, Can anyone give some
> clues for it :))
>
> cheers
> Mo.

Reply to this Message

Bob I - 19 Apr 2007 22:25 GMT

may also paste into Ms Paint or Microsoft Office Picture Manager and
make .jpg files.

> You're right, it is a function that I also think should be included in
> Excel.
[quoted text clipped - 9 lines]
>>cheers
>>Mo.

Reply to this Message

Gord Dibben - 19 Apr 2007 22:37 GMT

Chuck

I think I got this from John W. or Chip but disremember.

Sub SaveAsjpg()
' Saves the active chart as a jpg 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 & ".jpg", _
FileFilter:="jpg Files (*.jpg), *.jpg", _
Title:="Save chart as jpg file")
If FileName <> False Then ActiveChart.Export FileName, "jpg"
End If
End Sub

Gord Dibben MS Excel MVP

>You're right, it is a function that I also think should be included in
>Excel.
[quoted text clipped - 9 lines]
>> cheers
>> Mo.

Reply to this Message

CLR - 20 Apr 2007 00:43 GMT

Thanks Gord...........although I only occasionally have need to turn a chart
into a .jpg, I am really more interested in exporting drawing objects, and
or range selections, etc as .jpg's.........I'll play with that code some
tomorrow to see if I can get it will serve that purpose as well...

thanks again,
Vaya con Dios,
Chuck, CABGx3

> Chuck
>
[quoted text clipped - 30 lines]
> >> cheers
> >> Mo.

Reply to this Message

Debra Dalgleish - 20 Apr 2007 00:50 GMT

Andy Pope has a graphic exporter that might help you:

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

> Thanks Gord...........although I only occasionally have need to turn a chart
> into a .jpg, I am really more interested in exporting drawing objects, and
[quoted text clipped - 43 lines]
>>>>cheers
>>>>Mo.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

CLR - 20 Apr 2007 01:07 GMT

Thanks Debra, I'll take a look at it, but it says it's only for XL2K and
above, and most of my work is in XL97.........

Vaya con Dios,
Chuck, CABGx3

> Andy Pope has a graphic exporter that might help you:
>
[quoted text clipped - 52 lines]
> Contextures
> http://www.contextures.com/tiptech.html

Reply to this Message

Don Guillett - 19 Apr 2007 22:33 GMT

This will do what you want to a folder c:\a or create it if it doesn't exist

Private Sub ExportChartJPG()
On Error Resume Next
MkDir "c:\A"
Worksheets("Chart").ChartObjects(1).Chart.Export Filename:= _
"C:\A\MyChart.jpg", FilterName:="jpeg"
End Sub

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I am using MS Excel 2007, and want to export the chart to jpeg file,
> but i am not able to locate the functionality, Can anyone give some
> clues for it :))
>
> cheers
> Mo.

Reply to this Message

Michael Bednarek - 20 Apr 2007 12:23 GMT

>I am using MS Excel 2007, and want to export the chart to jpeg file,
>but i am not able to locate the functionality, Can anyone give some
>clues for it :))

PDFCreator is mostly used to produce PDF files (by printing to its
pseudo printer - there are many such programs available). However,
PDFCreator's "little extra" is that it can also print to Postscript
(PS), Encapsulated Postscript (EPS), PNG, JPEG, BMP, PCX, and TIFF.

In other words, you can convert anything you can print to those formats.

See: <http://sourceforge.net/projects/pdfcreator>
<http://www.pdfforge.org/products/pdfcreator>

Signature

Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

Reply to this Message

Don Guillett - 20 Apr 2007 13:02 GMT

Is this Vista compatible?

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>
>>I am using MS Excel 2007, and want to export the chart to jpeg file,
[quoted text clipped - 10 lines]
> See: <http://sourceforge.net/projects/pdfcreator>
> <http://www.pdfforge.org/products/pdfcreator>

Reply to this Message

Dave Peterson - 20 Apr 2007 12:59 GMT

Does it have to be a .jpg file?

If a .gif is ok, then this may work for you:

Save the file as a .htm file (say book1.htm)

You'll see a book1_files subfolder in that folder that contains lots of
files--and you'll see a .gif for each of your charts.

> I am using MS Excel 2007, and want to export the chart to jpeg file,
> but i am not able to locate the functionality, Can anyone give some
> clues for it :))
>
> cheers
> Mo.

Signature

Dave Peterson

Reply to this Message

Rate this thread: