View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Farooq Sheri Farooq Sheri is offline
external usenet poster
 
Posts: 37
Default change the name of the chart as it appears on the Chart Window

I have a workbook that has code for combobox which when executed generates a
chart on one of the sheets. Each time this code is run the chart name, as it
appears on the Chart Window, changes. I want to rename this to "Chart 1". As
a general question what is difference between ChartObject and Charts?

Thanks and regards
Farooq Sheri