Excel Table/Chart to JPEG for Web

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 procedure:

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/
_______
 
Back
Top