Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling seriescollection by name
I have given a name to one of the charts in a chartsheet. But in vba I could
not succeed in calling this chart by name for e.g. sheets("chart1').seriescollection(1).activate ======this suceeds but i have named a seriescollction ===sheets("chart1").seriescollction(1).name="rv"== ===ok this works But sheets("chart1").seriescollection("rv").activate ========fails any suggestions. I have tried to view newsgroups through google search bar I couldnt get satisfactory suggestions. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling seriescollection by name
You can't .Activate a series. Try to .Select it instead.
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ R.VENKATARAMAN wrote: I have given a name to one of the charts in a chartsheet. But in vba I could not succeed in calling this chart by name for e.g. sheets("chart1').seriescollection(1).activate ======this suceeds but i have named a seriescollction ===sheets("chart1").seriescollction(1).name="rv"== ===ok this works But sheets("chart1").seriescollection("rv").activate ========fails any suggestions. I have tried to view newsgroups through google search bar I couldnt get satisfactory suggestions. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling seriescollection by name
thank you.
Jon Peltier wrote in message ... You can't .Activate a series. Try to .Select it instead. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ R.VENKATARAMAN wrote: I have given a name to one of the charts in a chartsheet. But in vba I could not succeed in calling this chart by name for e.g. sheets("chart1').seriescollection(1).activate ======this suceeds but i have named a seriescollction ===sheets("chart1").seriescollction(1).name="rv"== ===ok this works But sheets("chart1").seriescollection("rv").activate ========fails any suggestions. I have tried to view newsgroups through google search bar I couldnt get satisfactory suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Chart SeriesCollection Formula | Excel Discussion (Misc queries) | |||
SeriesCollection question | Charts and Charting in Excel | |||
.SeriesCollection(2).Name and .Deselect | Charts and Charting in Excel | |||
Chart: range info from seriescollection? | Charts and Charting in Excel | |||
Possible to assign an array to a SeriesCollection | Excel Programming |