This is a strange objective. I'm sure it will not provide the benefits you
are seeking.

How large is your file? How much smaller is a copy of the file without the
charts? I just took a workbook with 66 charts, saved a copy without the
charts, and compared their file sizes. The workbook without charts is 90 kb,
the one with charts is 350 kb. That's under 4 kb per chart, and the charts
are rather complicated. How much space will you need to store all of the
information required to reproduce these charts, plus the VBA code? Will the
VBA procedure work reliably enough to recreate all of the charts without
issues? How much time will it take for you to develop the VBA procedures
this will require? Is it worth the effort in order to save the cost of disk
space (around $1 per 2 GB for a large external HD) or bandwidth?

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


"Ken Kazinski" wrote in message
...
Does anyone know where I can find code that will take a chart object and
create function (or a text file to be imported) for a chart.

I have a number of charts on a sheet and I want to delete the charts to
make
the file smaller and then run a macro to create the charts. After all the
data has been added.

Thanks,

Ken