ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel Table/Chart to JPEG for Web (https://www.excelbanter.com/charts-charting-excel/70787-excel-table-chart-jpeg-web.html)

sinofNOskSPAM at comcast dot net

Excel Table/Chart to JPEG for Web
 
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?




Jon Peltier

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?







All times are GMT +1. The time now is 11:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com