Declaring ActiveChart Object

[rbirch]

Thanks for reading this, I'm still kinda of new to VBA. I'm trying to figure out how I should define ActiveChart in way similar to how I defined wk6.

I tried

Please Login or Register  to view this content.

Below is the code as of now with active chart highlighted in bold.

Please Login or Register  to view this content.

[teylyn]

Hello,

the chart is active because the code just created it.

What is the question?

[rbirch]

Well, that is a good question ironically.

I believe my question is, "What is the parent of ActiveChart?". Do you know what it is?

I'm thinking Activeworkbook.activesheet("Sheet 1").activechart

[teylyn]

The active chart is a chart object. The parent of a chart object is the chart object collection. The parent of that is the sheet.

If you want to create a new chart:

Please Login or Register  to view this content.

If you want to manipulate an existing chart

Please Login or Register  to view this content.

[ELeGault]

To avoid names you can select and/or set charts with a value based on creation.
1 if it is the first and only chart on the sheet. If you are manipulating the 3rd chart then put 3...
ws.ChartObjects(1) instead of ws.ChartObjects("Chart 3") helps to know when creating loops on charts - not sure you really need it in this case but something to note -

Cheers