If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
How to save a graph as jpg file in Excel 2007
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 |
#3
|
|||
|
|||
How to save a graph as jpg file in Excel 2007
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 |
#4
|
|||
|
|||
How to save a graph as jpg file in Excel 2007
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 |
#5
|
|||
|
|||
How to save a graph as jpg file in Excel 2007
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 |
Thread Tools | |
Display Modes | |
|
|