Results 1 to 4 of 4

have chart titles for a graph with 2 different series (cluster column, line)

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2010
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2007
    Posts
    35

    Red face have chart titles for a graph with 2 different series (cluster column, line)

    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  [
    Last edited by kchen; 12-29-2010 at 04:12 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1