View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Roget Luo Roget Luo is offline
external usenet poster
 
Posts: 1
Default Anyway to change a Chart number?

Thanks for your advise. I'm not using codes to create a chart, I'm using
codes to adjust certain aspects of various charts in my spreadsheet in a
sequencial way, and the issue I'm having is that everytime I delete a chart
and create a new one, Excel assigns the next number to the chart, which
makes my programing very difficult.

Can you email me an example of creating a new chart and assigning a name of
my choice?

Thanks again.
"Andy Pope" wrote in message
...
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