How do I extract an Excel Chart as a graphics file?

[Dick Hanneman]

In earlier versions of MS Office/Excel, I have easily extracted as .gif files
charts that I created in Excel worksheets. Either I've simply forgotten how
or something's changed. Anyone help me through this?

[Don Guillett]

does this help?
Sub ExportChartGIF()
ActiveChart.Export Filename:="C:\a\MyChart.gif", _
FilterName:="GIF"
End Sub

Sub ExportChartJPG()
ActiveChart.Export Filename:="C:\a\MyChart.jpg", _
FilterName:="jpeg"
End Sub


--
Don Guillett
SalesAid Software
[email protected]
"**** Hanneman" <**** [email protected]> wrote in message
news:[email protected]...
> In earlier versions of MS Office/Excel, I have easily extracted as .gif
> files
> charts that I created in Excel worksheets. Either I've simply forgotten
> how
> or something's changed. Anyone help me through this?

[Dick Hanneman]

This would help if I were a programmer; I'm not. Formerly, my memory is that
when the Excel file saved, it also created a folder into which all graphics
files associated with the .xls file were saved. I simply opened that folder
and moved the .gif file to my website where I wanted the chart.

Is their a solution for a non-programmer?

Thanks for the effort.

**** Hanneman

"Don Guillett" wrote:

> does this help?
> Sub ExportChartGIF()
> ActiveChart.Export Filename:="C:\a\MyChart.gif", _
> FilterName:="GIF"
> End Sub
>
> Sub ExportChartJPG()
> ActiveChart.Export Filename:="C:\a\MyChart.jpg", _
> FilterName:="jpeg"
> End Sub
>
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "**** Hanneman" <**** [email protected]> wrote in message
> news:[email protected]...
> > In earlier versions of MS Office/Excel, I have easily extracted as .gif
> > files
> > charts that I created in Excel worksheets. Either I've simply forgotten
> > how
> > or something's changed. Anyone help me through this?
>
>
>

[Dave Peterson]

I bet you saved the file as .html to get that subfolder with the graphics.

**** Hanneman wrote:
>
> This would help if I were a programmer; I'm not. Formerly, my memory is that
> when the Excel file saved, it also created a folder into which all graphics
> files associated with the .xls file were saved. I simply opened that folder
> and moved the .gif file to my website where I wanted the chart.
>
> Is their a solution for a non-programmer?
>
> Thanks for the effort.
>
> **** Hanneman
>
> "Don Guillett" wrote:
>
> > does this help?
> > Sub ExportChartGIF()
> > ActiveChart.Export Filename:="C:\a\MyChart.gif", _
> > FilterName:="GIF"
> > End Sub
> >
> > Sub ExportChartJPG()
> > ActiveChart.Export Filename:="C:\a\MyChart.jpg", _
> > FilterName:="jpeg"
> > End Sub
> >
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "**** Hanneman" <**** [email protected]> wrote in message
> > news:[email protected]...
> > > In earlier versions of MS Office/Excel, I have easily extracted as .gif
> > > files
> > > charts that I created in Excel worksheets. Either I've simply forgotten
> > > how
> > > or something's changed. Anyone help me through this?
> >
> >
> >

--

Dave Peterson

[Mike]

I just learned this. Hold down the Shift key and click on the Edit menu. You
will get a different menu where you can copy picture, and then paste it.

"**** Hanneman" wrote:

> In earlier versions of MS Office/Excel, I have easily extracted as .gif files
> charts that I created in Excel worksheets. Either I've simply forgotten how
> or something's changed. Anyone help me through this?

[Dick Hanneman]

Perfect. That really isn't what I did before, I don't think, but had exactly
the same result -- thank you VERY much, Dave.

**** Hanneman

"Dave Peterson" wrote:

> I bet you saved the file as .html to get that subfolder with the graphics.
>
> **** Hanneman wrote:
> >
> > This would help if I were a programmer; I'm not. Formerly, my memory is that
> > when the Excel file saved, it also created a folder into which all graphics
> > files associated with the .xls file were saved. I simply opened that folder
> > and moved the .gif file to my website where I wanted the chart.
> >
> > Is their a solution for a non-programmer?
> >
> > Thanks for the effort.
> >
> > **** Hanneman
> >
> > "Don Guillett" wrote:
> >
> > > does this help?
> > > Sub ExportChartGIF()
> > > ActiveChart.Export Filename:="C:\a\MyChart.gif", _
> > > FilterName:="GIF"
> > > End Sub
> > >
> > > Sub ExportChartJPG()
> > > ActiveChart.Export Filename:="C:\a\MyChart.jpg", _
> > > FilterName:="jpeg"
> > > End Sub
> > >
> > >
> > > --
> > > Don Guillett
> > > SalesAid Software
> > > [email protected]
> > > "**** Hanneman" <**** [email protected]> wrote in message
> > > news:[email protected]...
> > > > In earlier versions of MS Office/Excel, I have easily extracted as .gif
> > > > files
> > > > charts that I created in Excel worksheets. Either I've simply forgotten
> > > > how
> > > > or something's changed. Anyone help me through this?
> > >
> > >
> > >
>
> --
>
> Dave Peterson
>

[MartinW]

Hi ****,

Another way is to select the chart and copy it with ctrl+c then open any
image processing software you have and paste into that. You can then save as
whatever image type you wish bitmap, jpeg, gif, tiff etc. The standard
microsoft Paint will do just fine.

HTH
Martin

[Dick Hanneman]

Thanks, Martin. I'll try that. I thought I had tried that, right-clicking
on the chart, but it didn't seem to offer the option to copy. But I'll try
it again. The earlier response solved my problem and the project is
complete, but it is a recurring need.

Appreciate your thoughtfulness.

****

"MartinW" wrote:

> Hi ****,
>
> Another way is to select the chart and copy it with ctrl+c then open any
> image processing software you have and paste into that. You can then save as
> whatever image type you wish bitmap, jpeg, gif, tiff etc. The standard
> microsoft Paint will do just fine.
>
> HTH
> Martin
>
>
>