Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Anyway to change a Chart number?
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Anyway to change a Chart number?
Roget Luo wrote,
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. Hold the shift key down and click on the chart. This selects the chart object. You can then click on the formula bar where it shows 'Chart 21' and rename (press enter after changing the name of the object). Ed Ferrero www.edferrero.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
remove cr character from a + number and change number to - 159cr | Excel Worksheet Functions | |||
How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) |