+ Reply to Thread
Results 1 to 5 of 5

Secondary chart type problem

  1. #1
    Forum Contributor
    Join Date
    06-21-2006
    MS-Off Ver
    2007
    Posts
    141

    Secondary chart type problem

    I am having a little trouble with a combination graph and I'm wondering if there is anyone out there able to solve it. I have attached the file for you.

    My issue is with the two "Goal" lines. One is green, the other is red on the graph. I am trying to put them above their respective actual results. The red should be above the orange column and the green should be above the green column.

    Can anyone help please?
    Attached Files Attached Files

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

    Re: Secondary chart type problem

    In order to get the offset for each column you need to use a xy-scatter chart type rather than Line.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    06-21-2006
    MS-Off Ver
    2007
    Posts
    141

    Re: Secondary chart type problem

    Thank you!

  4. #4
    Forum Contributor
    Join Date
    06-21-2006
    MS-Off Ver
    2007
    Posts
    141

    Re: Secondary chart type problem

    How do you change the offset?

  5. #5
    Forum Contributor
    Join Date
    06-21-2006
    MS-Off Ver
    2007
    Posts
    141

    Re: Secondary chart type problem

    Nevermind. I see the other range you used to make those changes.

    Thanks again.

+ 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