Gates Is Antichrist
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 1,961
Forgive me for I am stumbling through an assignment using charts, so I may misstate or babble here
I have a chart that I want a dynamic title on. Thus I believe that I want to plug activechart.charttitle.caption based on input assumptions.
What I'm wondering is how to identify the chart itself. From the 'Chart Window' (from right clicking an empty area of the chart), I see one possible name in the title bar; from activechart.parent.name in Watch window I see "Chart 1" . So for starters I don't know the name of my only chart!
At ANY rate Charts.Count is zero! Charts(1) and charts("Chart 1") are rejected by the Watch window.
Going back to how I started, I guess I'll be okay if I can just know how to make my [sole] chart the "ActiveChart" but beyond that I'm quite clueless. (I don't want to have to manually click the chart to do so either.) Can someone walk me through what I need to do, if this is clear enough?
TIA
I have a chart that I want a dynamic title on. Thus I believe that I want to plug activechart.charttitle.caption based on input assumptions.
What I'm wondering is how to identify the chart itself. From the 'Chart Window' (from right clicking an empty area of the chart), I see one possible name in the title bar; from activechart.parent.name in Watch window I see "Chart 1" . So for starters I don't know the name of my only chart!
At ANY rate Charts.Count is zero! Charts(1) and charts("Chart 1") are rejected by the Watch window.
Going back to how I started, I guess I'll be okay if I can just know how to make my [sole] chart the "ActiveChart" but beyond that I'm quite clueless. (I don't want to have to manually click the chart to do so either.) Can someone walk me through what I need to do, if this is clear enough?
TIA