MrExcel Publishing
Your One Stop for Excel Tips & Solutions

upper limit to Graphs in a worksheet


Posted by Mark on August 09, 2001 2:11 AM

I have a problem on my pc running winnt4 and office 97. When I insert another graph into my worksheet which has got lots and lots of graphs aready it crashes. Is there an upper limit to the number of graphs & charts you can have in an excel file.


Posted by Mark W. on August 09, 2001 6:30 AM

The answer to all Excel "limits" questions...

...can be found by searching the Excel Help
facility for the word, "limit". Specifically,
your chart limit question can be found in the
Help topic for "Charting specifications". The
answer is: "Limited by available memory".

Posted by Ian on August 09, 2001 2:30 PM

Mark! searched and searched could find the limit to the amount of Excel #value error i'd endure before giving up :)

Posted by Mark W. on August 09, 2001 2:58 PM

You must go to...

...some mountain top in the Himalayas for that
answer!! : )

Posted by Ian on August 12, 2001 8:54 AM

Grin.........:-))