+ Reply to Thread
Results 1 to 4 of 4

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

Hybrid View

kchen have chart titles for a graph... 12-28-2010, 03:20 AM
Andy Pope Re: have chart titles for a... 12-28-2010, 06:32 AM
kchen Re: have chart titles for a... 12-28-2010, 11:41 AM
Andy Pope Re: have chart titles for a... 12-29-2010, 06:43 AM
  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.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

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

    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

    Read this to understand why we ask you to do this
    Cheers
    Andy
    www.andypope.info

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

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

    Hi sorry, I didn't realize the protocol for this. I haven't made any strides on this problem, and I have not had any responses to the question, that is why I was posting here and hoping for people's input.

    My original link is here:
    http://www.mrexcel.com/forum/showthr...54#post2555654

    I appreciate your time. Thanks

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

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

    So what happens if you set the chart title to some static text, does it appear?

             With ActiveChart
                    .HasTitle = True
                    .ChartTitle.Text = "Title source is the Data table but chart titles do not appear"  
                End With
    If the title appears then you need to check the cell the chart title is referencing to make sure it contains text.

+ Reply to Thread

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