+ Reply to Thread
Results 1 to 7 of 7

Charting Employee name and product value over a given period

  1. #1
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    221

    Cool Charting Employee name and product value over a given period

    Hi Guys

    I am trying to put together a chart that shows the perfomance of emplyees over a year.

    you first select the employee from a drop down, it then pulls data from another worksheet and thus the chart is compiled.


    cheers

    stephen
    Attached Files Attached Files
    Last edited by stephen1000; 12-11-2008 at 06:39 PM.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,280
    Hi,

    Please see attachment using the OFFSET function.
    Attached Files Attached Files
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    221

    Smile

    Quote Originally Posted by sweep View Post
    Hi,

    Please see attachment using the OFFSET function.
    Hi Sweep,

    you are getting their, some work some dont


    and could you explain the cells above the drop down

    Thanks for what you have done

  4. #4
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    221

    Smile

    Quote Originally Posted by stephen1000 View Post
    Hi Sweep,

    you are getting their, some work some dont


    and could you explain the cells above the drop down

    Thanks for what you have done
    Hi sweep, I have edited the staff list but 3 do not show any figures
    Kerry, Steve, Helen

    Any Ideas why

  5. #5
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,280
    In your first example I had to "trim" the list of names as there were extra spaces in them. Make sure this isn't the case for the ones you've just added.

  6. #6
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    221

    Smile

    Quote Originally Posted by sweep View Post
    In your first example I had to "trim" the list of names as there were extra spaces in them. Make sure this isn't the case for the ones you've just added.
    Hi Sweep, Firstly thanks a mil for what you have done already.

    not quite sure what you mean by the trim thing

    as you can see from my previous post all but three names work, but they are not sequncial Kerry, steve ,, helen

    hope you can shed light on this

    cheers

    stephen

  7. #7
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    221
    Hi Dave

    Sorted it thanks again


    stephen

+ 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