![]() ![]() With the worksheet active run the followingįor your purposes, adding series etc, you will want to be dealing with "cht". Try this - in a new workbook insert a simple embedded chart on a worksheet. I used the function ActiveChart.Name and received back "Chart8 Chart1" Now Chart8 is the only Chart in the workbook.Įmbedded charts have two names. ![]() Now it doesn't matter if the chart becomes non-active as long as you maintain the object reference "cht". Very simple, if the chart you want to deal with is active (before starting your code), start like this Then without that line almost everything is perfect. When I had the operation wks.Activate it also caused the ActiveChart object get set to Nothing. I'm confused, what's the difference between Seriescollection.add and Add Series The SeriesCollection.Add works great and does exactly what I want. I don't follow what you mean by picking up the "row number" I tried the Add Series and the process seem to get confused as it picked up the row number too.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |