11

I want to save bar chart from Microsoft Excel 2010 for using as jpg.

Is there a way for saving it?

3
  • Say more about your environment. Are you trying to do this in an external application? Or in a macro in Excel? Or within Excel itself?
    – davehale23
    Commented Apr 23, 2012 at 14:17
  • I want to save from Excel.
    – ThanaDaray
    Commented Apr 23, 2012 at 14:26
  • 2
    In VBA charts have an Export() method.
    – Tim Williams
    Commented Apr 23, 2012 at 15:07

3 Answers 3

11

Select the graph, hit copy (ctrl+c or right click and select copy) and then paste into paint (or any image editing software) to save in the correct format.

4
  • Is there any better way than that?
    – ThanaDaray
    Commented Apr 23, 2012 at 14:18
  • 1
    Also, selecting "Home/Clipboard/Copy->Copy As Picture" will give you the option of copying as-printed or as-shown-on-screen. The "on screen" option (suprisingly) appears to give a much higher resolution, if that is helpful...
    – Rob I
    Commented Apr 23, 2012 at 14:19
  • 1
    No, there is no native option to save a graph as a picture - which seems like an oversight in my opinion.
    – unfrev
    Commented Apr 23, 2012 at 14:49
  • @unfrev - from VBA you can use the chart's Export() method. It allows you to specify which format to use.
    – Tim Williams
    Commented Apr 23, 2012 at 15:06
7

As @TimWilliams noted in the comments, charts have an Export method in VBA. Here's a sample macro that will save the active chart as an image file in your workbook's directory.

The file type has been changed from the JPG you requested to PNG, which is a better image file format for line art like Excel charts. JPG is optimized for photographic images.

Sub savechart()
    ActiveChart.Export Filename:=ActiveWorkbook.Path & "\yourchart.png", Filtername:="PNG"
End Sub
1
  • Good suggestion about PNG format instead of JPG.
    – Kamil
    Commented Sep 7, 2014 at 0:50
0

Office 2010: Select the Chart and Copy the chart from Excel; Paste Special as JPEG into Word; Right Click on picture in Word and select Save As Picture. Job done

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .