Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
When ever I wish to create a new series, no big deal:
Dim SeriesRandTarget As Series Set SeriesRandTarget = myChart.SeriesCollection.NewSeries As long as I have the object, I can use it. If I set the name attribute as in SeriesRandTarget .Name = "Hello" I can collect it later if needed by: Set myseries = myChart.SeriesCollection("Hello") But what about this? What is the new series name I just created in the below example? (The macro recorder has me in this fix!) myChart.SeriesCollection.Paste Rowcol:=xlColumns, SeriesLabels:=False, _ CategoryLabels:=True, Replace:=False, NewSeries:=True The next recorded step is myChart.SeriesCollection(4).Select I tried slipping in Name:="My Name", but it croaks. How do you find this series? thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding series index if I know the Series Name | Charts and Charting in Excel | |||
Toggle Chart Series Objects On/Off | Charts and Charting in Excel | |||
How to store the lengthy value in Series collection? | Charts and Charting in Excel | |||
Help needed in finding specific series via row. | Excel Worksheet Functions | |||
Changing the color of a Series Collection using visual basic? | Charts and Charting in Excel |