Looks like you can do it if you copy the picture of the range into an empty chart and then export that.

http://www.mrexcel.com/forum/showthr...save-as-a-file