+ Reply to Thread
Results 1 to 7 of 7

Double dropdown

  1. #1
    Forum Contributor
    Join Date
    10-16-2008
    Location
    Iowa
    Posts
    121

    Double dropdown

    Andy, I am trying to make a chart with two drop downs, graphing two lines on the same graph. I am using:
    LABELS OFFSET(ProjChart!$A$2,0,1,1,7)
    LABELS1 OFFSET(ProjChart!$A$6,0,1,1,7)
    DATA OFFSET(LABELS,$A$2,0)
    DATA1 OFFSET(LABELS1,$A$6,0)
    Metric_Name OFFSET($A$2,$A$2,0,1,1)
    Metric_Name1 OFFSET($A$6,$A$6,0,1,1)
    Chart values: Metric_Name,DATA
    Chart values1: Metric_Name1,DATA1
    Where the first group of data is in cells A2:U5, with row 2 containing dates; the second group is in cells A6:U9, with row 6 containing the same dates.
    I tried to set graph data as ProjChart!Metric_Name = ProjChart!DATA and ProjChart!Metric_Name1 = ProjChart!DATA1, but only the top set of data displays.

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

    Re: Double dropdown

    Can you post your workbook
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    10-16-2008
    Location
    Iowa
    Posts
    121

    Re: Double dropdown

    I guess it did not make the post. Here it is.
    Attached Files Attached Files

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

    Re: Double dropdown

    When I applied the named ranges to the series it all seems to work as advertised.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    10-16-2008
    Location
    Iowa
    Posts
    121

    Re: Double dropdown

    You're right. Apparently I did not apply the ranges correctly. Thanks!

  6. #6
    Forum Contributor
    Join Date
    10-16-2008
    Location
    Iowa
    Posts
    121

    Re: Double dropdown

    Well, I tried to add another line, using the same approach as before. What are the steps to apply the 3rd named range to the series?

  7. #7
    Forum Contributor
    Join Date
    10-16-2008
    Location
    Iowa
    Posts
    121

    Re: Double dropdown

    Disregard. I just did it. I needed to make sure the tab name was included.

+ 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