View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Excel Table/Chart to JPEG for Web

1. Use gif or png, which are designed for line art and similar images, not
jpg, which is designed for photos and is terrible at line art.

2. If you know VBA, you could use a command like this one from the immediate
window or within a procedu

ActiveChart.Export ActiveWorkbook.Path & "\Chart001.png", "PNG"

3. Check out John Walkenbach's Chart Tools utility, a free Excel add-in
which includes chart image exporting as one of its tools. Download it from
http://j-walk.com.

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


"sinofNOskSPAM at comcast dot net" wrote in message
. ..
I'm looking for a simple (read cheap) program that I can copy/paste or
print
into and adjust the pixel count (keeping aspect ratio) and resolution
(dpi)
for upload to web in jpeg format.

Ideas?