Your question "a more efficient way to have the charts on the file". Without
knowing how your data is set up it is not possible to answer this. However,
if you can set up the data so that it can be Autofiltered then you can have
just one chart (or maybe a suite of charts) and it becomes dynamic to the
range displayed with Autofilter.

--
Regards,

OssieMac


"Ovatsug" wrote:

I have neary 300 charts on my excell file, and everytime i try to add morei
get a error window and excell is closed. is there a way to add more charts or
a more efficient way to have the charts on the file?