+ Reply to Thread
Results 1 to 2 of 2

Need help on Line Chart with Multiple Variables

  1. #1
    Registered User
    Join Date
    09-29-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Need help on Line Chart with Multiple Variables

    Hi there,

    This is my first post on this forum, so bare with me.
    I am trying to chart the performance of telesales personnel at my workplace.
    I would like to use a line chart to 'chart' their performance over a period of time (so Y-axis = Date).

    The Variables are:

    Total Call Time
    Total Talk Time

    I would like the option to expand the chart as time progresses, so I can continue to update the chart with staffs performance, and get a clear picture of their avg. performance over time.

    Please find attached the data sheet.

    Any help on this would be greatly appreciated.

    Many thanks
    Alex
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Need help on Line Chart with Multiple Variables

    I would suggest that a Pivot Chart is the way you might go.

    If you specify your names as legend fields/column labels, the dates as row labels and either of the numbers as values you will get a chart which makes it easy to compare performance to each other and invidually over time.

    See Excel Help for more details.
    Martin

+ 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