[RESOLVED] Saving the Chart

[pvbangera]

Hi all,

How can I save an Excel chart in JPG/TIFF format?

Pls guide.

[Siddharth Rout]

To save an excel 2000 chart or graph as 'JPEG format' You will need an Excel spreadsheet that includes a chart or graph, and
a graphics program such as Adobe Photoshop or Microsoft Paint installed on your computer.

Open your chart in Excel.

With Excel running on your computer, choose File > Open . . .
Locate your spreadsheet in the 'Open' dialog box and click the 'Open' button.

Select the Chart

Click on the the chart you wish to save. Little boxes will appear around the border, indicating that the chart has been selected.
Choose Edit > Copy from the menu bar.

Make sure the whole chart is selected. If you click on just the center of the chart, it may only select one part of the chart and not allow you to copy it.

Save the Chart for the Web

Open the graphic editing program of your choice.
In the graphic editing program, choose File > New from the menu bar.
Copy the chart into the graphic editing program by choosing Edit > Paste from the menu bar. Your chart should now appear in the window.
To save your chart, choose File > Save As from the menu bar.
In the "Save as type" box, change to Graphic Interchange Format (*.gif) or as a "JPEG" (*.jpg) file.

Hope this is what you are looking for...

[pvbangera]

My dear koolsid...

I dont wanna do it manually. I wanna code the whole process...IN VISUAL BASIC.

Are you getting me?

[Siddharth Rout]

Hi

Hi all,

How can I save an Excel chart in JPG/TIFF format?

Pls guide.

I am sorry your qoute doesn't say much that you wanted to "code" the entire process...

Anyways

I don't think it is possible (I might be wrong....) as we are using a Third Party Software to open and save the chart in the required format...

If I come across anything. I'll update this thread.

[Siddharth Rout]

Here's the code

Dim mychart As Chart
      Set mychart = ActiveSheet.ChartObjects("Chart 1").Chart
      mychart.Export Filename:="C:\Chart.gif", FilterName:="GIF"

I have tested it... it works

Hope this is what you were after...

[Siddharth Rout]

I have tested it for JPG and Tiff formats. It works fine for those as well. The clarity of the GIF is far better than the Jpg...

[pvbangera]

Thx for the posts.