Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing chart name and sorting by chart name
Hi All,
i have 25 charts in a sheets (Chart Name: Chart 1, chart 2 chart 3 etc.). Now i want to change the name chart 25 to chart 1. but i am not able to do the same as there is already a chart with the same name, this is what i think. the charts in the sheets are not placed in the sorted order by their names. so i want to rename the charts from the first chart in the sheet till last and then sort the charts by their name. please help. thanks, navin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing chart name and sorting by chart name
Could you use other name, such as "Cht 1" etc? Then it will bw easy. Or you
need do it twice: Change it to Cht1, then change it back to Chart 1 again, I guess. -- VBA "navin" wrote: Hi All, i have 25 charts in a sheets (Chart Name: Chart 1, chart 2 chart 3 etc.). Now i want to change the name chart 25 to chart 1. but i am not able to do the same as there is already a chart with the same name, this is what i think. the charts in the sheets are not placed in the sorted order by their names. so i want to rename the charts from the first chart in the sheet till last and then sort the charts by their name. please help. thanks, navin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicating Pivot Chart / Changing Pivot Chart data range | Excel Discussion (Misc queries) | |||
Sorting Chart | Excel Discussion (Misc queries) | |||
sorting a pie chart | Charts and Charting in Excel | |||
Cannot Activate Chart Area in Chart. Chart Object Failed | Excel Programming | |||
Changing chart title changes position of chart | Excel Programming |