Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I export an excel 2003 chart to a .jpg?
I am trying to find a way to export an excel chart directly to a .jpg image
for upload. I know many work arounds, but seek a simple answer for an end-user. The closest solutions I have found are "Save As Webpage", which results in a ..gif, and "Send to Mail recipient" which results in a .bmp Any suggestions? |
#2
|
|||
|
|||
Hi,
You can use the export method of a chart. Change the folder location to suit. Activechart.export "c:\temp\mychart.jpg" Cheers Andy Jason Krause wrote: I am trying to find a way to export an excel chart directly to a .jpg image for upload. I know many work arounds, but seek a simple answer for an end-user. The closest solutions I have found are "Save As Webpage", which results in a .gif, and "Send to Mail recipient" which results in a .bmp Any suggestions? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
I suggest you export as GIF or PNG rather than JPG. JPG is designed for
photographic images, with gradual changes in color, while GIF and PNG are good for bitmapped representations of drawn objects, with discrete constant colors and sharp transitions between adjacent colored regions. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Andy Pope wrote: Hi, You can use the export method of a chart. Change the folder location to suit. Activechart.export "c:\temp\mychart.jpg" Cheers Andy Jason Krause wrote: I am trying to find a way to export an excel chart directly to a .jpg image for upload. I know many work arounds, but seek a simple answer for an end-user. The closest solutions I have found are "Save As Webpage", which results in a .gif, and "Send to Mail recipient" which results in a .bmp Any suggestions? |
#4
|
|||
|
|||
I agree, but the webapp (not my fault) only accepts jpg. I'm working on
getting that silly limitation changed to. "Jon Peltier" wrote: I suggest you export as GIF or PNG rather than JPG. JPG is designed for photographic images, with gradual changes in color, while GIF and PNG are good for bitmapped representations of drawn objects, with discrete constant colors and sharp transitions between adjacent colored regions. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Andy Pope wrote: Hi, You can use the export method of a chart. Change the folder location to suit. Activechart.export "c:\temp\mychart.jpg" Cheers Andy Jason Krause wrote: I am trying to find a way to export an excel chart directly to a .jpg image for upload. I know many work arounds, but seek a simple answer for an end-user. The closest solutions I have found are "Save As Webpage", which results in a .gif, and "Send to Mail recipient" which results in a .bmp Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Activating a Chart object | Charts and Charting in Excel | |||
Updating Excel OLE chart data in PPT from Excel | Charts and Charting in Excel | |||
Displaying charts from excel 2003 in excel 2002? | Excel Discussion (Misc queries) | |||
quattro pro converter Excel 2003 | New Users to Excel |