Thread: Anyway to change a Chart number?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default Anyway to change a Chart number?
Hi,

Whilst you can not specify the automatic name you can change the name of
the newly create chart with code.

If you need more help post you existing code.

Cheers
Andy

Roget168 wrote:
Is there a way to give a chart a specific number? Everytime I delete and
create a new chart, Excel automatically give it the next sequential number,
I'm running VB in the charts so it's a pain to constantly changing my scripts
in VB. Thanks in advance.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply With QuoteReply With Quote