Paste special question

  • Thread starter Thread starter scooby19630
  • Start date Start date
S

scooby19630

Is there a know way to paste a chart into a new workbook as a jpeg/pn
using paste special if the chart was created with autofiltered data
Currently, paste special cannot be selected from the pulldown menu o
charts created/updated with autofiltered data.

THX
G.Shar
 
Here are a couple that can export a chart to a file

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
 
Whether the chart came from a filtered list or not, if you copy it and
select a spot on a worksheet, you can only paste it as a chart. But you
can copy it as a picture in the first place.

Hold Shift while you select the Edit menu, and Copy changes to Copy
Picture. select the option you want (png equates to a bitmap, and IMO
you should avoid jpg for a chart; I usually use the picture format,
which is a metafile comprised of scalable objects). Then you can paste
the copied picture anywhere.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top