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
|
|||
|
|||
Exporting graphs from Excel
How can I export an Excel graph as a TIFF file?
|
#2
|
|||
|
|||
Exporting graphs from Excel
Dave -
This line of VBA does it: ActiveChart.Export "C:\TEMP\TestChart.tif", "TIFF" On my system I can also export using "GIF" and "PNG" formats, but it choked on "BMP". "JPG" is also supported, but I advise anyone not to use this, because it's only good for pictures with continuously shaded regions, like photos and paintings. "GIF" is good for line drawings and pictures with sharp color transitions. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Dave Beebe wrote: How can I export an Excel graph as a TIFF file? |
Thread Tools | |
Display Modes | |
|
|