PC Review

Thread Tools Rate Thread

How to save a graph as jpg file in Excel 2007

New Member
Join Date: May 2011
Posts: 1
      17th May 2011
hi rfengr_1,

your macro works great to save one chart to a .gif by the charts file name. thank you very much. I was wondering if it would be possible to have a macro to save multiple charts by the same method? i basically have about 10 charts in my excel file and the charts constantly update. so it would be great if that macro could save all charts the same way.

Thank you for your help.
Reply With Quote
New Member
Dezy's Avatar
Join Date: May 2011
Location: Gujarat
Posts: 11
      28th May 2011
Ya sure i would try and tell u now
Reply With Quote
New Member
Join Date: Feb 2012
Posts: 1
      14th Feb 2012
Originally Posted by Dezy View Post
After your chart has been prepared go to follow the steps to covert excel cahrt into jpg format
1. File > Save as > Select "Web Page (*.htm;*.html)
2.Choose Selection: Chart radio button
3. Click on Publish
4. Choose the destination where you want to save the chart by clciking on Browse
5. Again click on Publish
6. Then open the file you have saved (e.g. Chart.htm or Cahrt.html)
7. After opening the file right click on the chart and choose Save Image As
8. Then type the file name chart.jpg (in this you have to chnage the format by because by default it would be saved in gif format so you need to change it into jpg format so must save the file name with .jpg extension)
9. Click on save (please choose the destination where you want to save)
10. Now your excel chart is in jpf format

I needed help with this as well. All the steps worked until I needed to save the image as a jpg file. Even though I input the file extension it did not save as a Jpg. I also did not have the option to "save image as", just a save as option. Not converting a graph but design that has text and an image added to it.
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bar graph and stacked bar graph on same graph BRB Microsoft Excel Misc 3 22nd Aug 2008 07:26 PM
Nokia PC Suite on Laptop - nokia_error.jpg [0/3] - nokia_error2.jpg [0/2] - nokia_error2.jpg [0/2] - nokia_error2.jpg [0/2] Bob Moore Windows XP Help 1 22nd Feb 2006 01:50 PM
Nokia PC Suite on Laptop - nokia_error.jpg [0/3] - nokia_error2.jpg [0/2] - nokia_error2.jpg [0/2] Bob Moore Windows XP Help 0 22nd Feb 2006 01:28 PM
Hyperlinkage of one graph with another graph or Drill down graph =?Utf-8?B?U2FuamF5IEt1bWFyIFNpbmdo?= Microsoft Excel Charting 1 3rd Jan 2006 01:22 PM
I can't save images as jpg. I am only given bitmap as a choice to save pics off of web. Why can't I get the jpg option? =?Utf-8?B?Q2Ftcm9u?= Windows XP Photos 1 28th Apr 2004 10:31 PM




All times are GMT +1. The time now is 12:17 AM.