export chart as jpg

  • Thread starter Thread starter hke
  • Start date Start date
H

hke

With the j-walk charting tool I can for example export a chart in jp
format - but can this operation be done by a macro? if so how
 
You can use code similar to the following:

ActiveChart.Export Filename:="C:\Data\Chartpic.jpg", _
FilterName:="jpeg"
 
May I suggest you use GIF instead of JPG? GIFs are much better suited to line
drawings such as charts, with relatively few distinct colors, often covering large
areas. JPGs are better for photographic artwork, with continuously varying colors
across the image.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Chart as TIFF or JPG 8
Problem exporting Chart as a jpg 4
export excel chart to image from C# without using interop 0
How to Export Gmail Emails to PST Format? 6
Excel 2010. How to copy chart format to all charts in sheet 2
Help: Chart & data 1
chart to email 3
export chart as wmf 1

Back
Top