Thread: Chart Name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zone Zone is offline
external usenet poster
 
Posts: 269
Default Chart Name

I have an embedded chart on a worksheet. Each time I run my macro, I
delete the existing chart and create it fresh. I would like for its
name to remain Chart 1, but Excel renames it each time it is created,
to something like "Sheet 1 Chart 22". I'm not sure this makes much
difference, but I am curious as to Excel's "memory" of the deleted
charts, and will I run into trouble when I get to chart names like
Sheet 1 Chart 280309387. (Excel 2002)
Thanks, James