+ Reply to Thread
Results 1 to 5 of 5

how to best show data on graph?

  1. #1
    Forum Contributor
    Join Date
    04-27-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    113

    how to best show data on graph?

    Hello

    Im trying to show data for individuals from a drop down list, and its based on a few criterias

    Im trying to make my index, match formula lookup
    a) look the year (i.e. 2010, 2011); person's name, revenue report to use.

    the part im struggling with is, how can i reference the person's name to be a match source?

    here is my formula:

    =INDEX(Table9,MATCH($D$7,INDEX(Table9,0,1),0)+1,MATCH($C12,INDEX(Table9,1,0),0))

    it works perfectly, but im not sure how i can make it reference the employee name

    D7 = year selection from drop down (2010, 2011)
    C12 = period i want data to show for (which week i want show i,e. P1W1, P1W2 etc)

    that portions works fine and provides me with correct info., however I have the person's name in cell D6, not sure how i can incorporate that into the formula?

    also, my graph appears to not be working, the scroll graph :s

    Im grateful for the help! Cheers
    Attached Files Attached Files
    Last edited by step_one; 05-16-2011 at 03:15 PM.

  2. #2
    Forum Contributor
    Join Date
    04-27-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    113

    Re: how to best show data on graph?

    hello, i have made changes to my request (edited my initialy request)...pls see above question! thank you.

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: how to best show data on graph?

    Hello,

    if you want to get a good overview and tutorials for dynamic charts, take a look at http://peltiertech.com/Excel/Charts/Dynamics.html

    If you get stuck on a specific issue, please pipe up.

    cheers,

  4. #4
    Forum Contributor
    Join Date
    04-27-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    113

    Re: how to best show data on graph?

    Hello

    Thanks for getting back to me.

    The main issue I'm having, more than the chart itself, is integrating a match for the person's name.

    In my workbook, I have a drop down list in cell D6 for different employee names; i would like my formula to be indepent on that as well as the year 2010 and 2011.

    So I'm not sure how i can add Match(D6(index(table9,0,1),0) to my formula. atleast, that is my issue, help with that is grately appreciated!

    Cheers

  5. #5
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: how to best show data on graph?

    Hello,

    you need to adjust the row in the Index/Match by the row offset for that person. For example in D11 and copied down

    =INDEX(Table9,MATCH($D$7,INDEX(Table9,0,1),0)+1+MATCH($D$6,INDEX(Table9,0,2),0)-2,MATCH($C11,INDEX(Table9,1,0),0))

    cheers,

+ 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