How to save a graph as jpg file in Excel 2007

Hello,

I need to save some Excel Graphs as jpg files. How can I do it?

Thank you.

Athena

Hi,

Requires code. Syntax: Activechart.Export filename , filtertype

You can use this in the immediate window,(ALT+F11 CTRL+G)

Activechart.export "C:\mychart.jpg"

Cheers
Andy

Athena wrote:
Hello,

I need to save some Excel Graphs as jpg files. How can I do it?

Thank you.

Athena

--

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

Hello Andy,

Thank you very much. It worked. Do you happened to know how to set the
resolution of the jpeg image as well?

Athena

"Andy Pope" wrote in message
...
Hi,

Requires code. Syntax: Activechart.Export filename , filtertype

You can use this in the immediate window,(ALT+F11 CTRL+G)

Activechart.export "C:\mychart.jpg"

Cheers
Andy

Athena wrote:
Hello,

I need to save some Excel Graphs as jpg files. How can I do it?

Thank you.

Athena

--

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

There is no control over the resolution of the exported image. You get
whatever the resolution of the screen is.

By the way, JPG is really the wrong format for a chart. Most computer
graphics are better suited to PNG or GIF, which are also possible using the
Chart.Export method Andy provided. The JPG format was designed for
photographic images, which have areas of gradually changing colors and
shadows. JPG does poorly where there are sharp transitions of colors, for
example, along the edges of shapes and in text. For these situations, which
are what charts are made of, PNG is probably your best choice.

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


"Athena" wrote in message
...
Hello Andy,

Thank you very much. It worked. Do you happened to know how to set the
resolution of the jpeg image as well?

Athena

"Andy Pope" wrote in message
...
Hi,

Requires code. Syntax: Activechart.Export filename , filtertype

You can use this in the immediate window,(ALT+F11 CTRL+G)

Activechart.export "C:\mychart.jpg"

Cheers
Andy

Athena wrote:
Hello,

I need to save some Excel Graphs as jpg files. How can I do it?

Thank you.

Athena

--

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

Jon,

Thank you. I did not know this.I shall try to save them as png files.

Athena

"Jon Peltier" wrote in message
...
There is no control over the resolution of the exported image. You get
whatever the resolution of the screen is.

By the way, JPG is really the wrong format for a chart. Most computer
graphics are better suited to PNG or GIF, which are also possible using
the Chart.Export method Andy provided. The JPG format was designed for
photographic images, which have areas of gradually changing colors and
shadows. JPG does poorly where there are sharp transitions of colors, for
example, along the edges of shapes and in text. For these situations,
which are what charts are made of, PNG is probably your best choice.

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


"Athena" wrote in message
...
Hello Andy,

Thank you very much. It worked. Do you happened to know how to set the
resolution of the jpeg image as well?

Athena

"Andy Pope" wrote in message
...
Hi,

Requires code. Syntax: Activechart.Export filename , filtertype

You can use this in the immediate window,(ALT+F11 CTRL+G)

Activechart.export "C:\mychart.jpg"

Cheers
Andy

Athena wrote:
Hello,

I need to save some Excel Graphs as jpg files. How can I do it?

Thank you.

Athena

--

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