How do I automatically pull a chart title (from a data table on another sheet) and make it appear on a graph that has both cluster columns and a line?
Initially, when I only had a cluster column, the chart title showed up automatically. Now, after adding the line as a second X series the chart title disappears. I want to add in a code so that the chart title still shows up.
The code is a bit complex:
1. the data table has about 80 independent variables
2. If the user wants to see a graph then there is a "1" denoting "yes"
3. The code then graphs an individual cluster-line graph for each variable (on the "Graphs" sheet).
4. Finally, I need help: how do I change this code so that the chart title shows up for each graph?
Appreciate your help, thanks
With ActiveChart
.HasTitle = True
.ChartTitle.Text = "='Data'!$O$ & CurRow" '[COLOR="red"]Title source is the Data table but chart titles do not appear [
Bookmarks