Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Dec 2006
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Converting Excel graphs to jpg (MS Office 2003 Basic Edition)

    I am having extreme difficulty converting graphs I have produced in Excel into the jpg format required by my publisher. In fact I have no idea how to do it, and have resorted to asking various designer-type people to do it for me, but have always found that text was lost and/or the size and proportions of the graph changed - which may be something to do with the fact that designers usually work on Macs, though I'm not sure. I cannot believe it should be such a problem. Can anybody tell me how to save an Excel graph as a jpg while keeping the size/proportion the same, and while retaining all original data? Alternatively, I have been able to save as the OpenDocument Drawing (.odg) format used in StarOffice Draw, so can anybody tell me how to convert this format into jpg? Help required urgently!

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Converting Excel graphs to jpg (MS Office 2003

    Hi there,

    A great favourite of the Lounge is Irfanview software. A quick copy and paste into the application and you have a graphic.

    Excel graphs use minimal colours so it would be best to save as GIF format which uses 256 colours (hence file size is smaller)

    Oh BTW its <img src=/S/free.gif border=0 alt=free width=30 height=15>
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Converting Excel graphs to jpg (MS Office 2003 Basic Edition)

    You can do this in VBA. For example:
    - Select the chart.
    - Activate the Visual Basic Editor (Alt+F11)
    - Activate the Immediate window (Ctrl+G)
    - Type the following, substituting the file name you want (you can also specify the path if you wish):
    <code>
    ActiveChart.Export "Test.jpg", "JPG"
    </code>
    - Press Enter.
    That's it!

    Note: a .jpg file is just a picture, it doesn't contain the original data.

  4. #4
    Lounger
    Join Date
    Dec 2006
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting Excel graphs to jpg (MS Office 2003 Basic Edition)

    Thanks guys, that's fabulous, all fixed. Why didn't I ask months ago and save all that stress??

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting Excel graphs to jpg (MS Office 2003 Basic Edition)

    Another way is to use the elusive camera tool, which is built in to XL, but not well known to Jo public.
    http://www.f-keys.co.uk/pdf/Using the Camera Tool.pdf shows you how to make it available and use it.
    After taking a snapshot of the desired range, just paste into a graphics program and save in whatever format you like.

    BTW, I'd suggest .GIF or .PNG over JPEG.

    Alan

  6. #6
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting Excel graphs to jpg (MS Office 2003 Basic Edition)

    Devo:

    As if you don't already have enough suggestions, you can also copy the graph and paste it into PowerPoint. When saving from PPt, you can choose from several graphic types from the 'Save As Type' drop-down to save an individual slide as a graphic file.

    Regards,

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •