Results 1 to 11 of 11

Combo Line & Scatter Chart

Threaded View

  1. #1
    Registered User
    Join Date
    02-26-2010
    Location
    St. Louis, MO
    MS-Off Ver
    Excel 2007
    Posts
    55

    Combo Line & Scatter Chart

    Hello-

    I am trying to do a combo scatter and line chart. The scatter portion of the chart is going to show the # of tickets we have completed since each day 2/15/10. The line portion is going to show the ticket capacity depending on how many people we have on the help desk. The info is as follows:

    Scatter Chart

    # of Tickets
    153
    155
    132
    113
    93
    156
    124
    154
    127
    183
    167
    185
    115
    160
    185
    188
    189
    271
    301
    138
    140
    494

    Line Chart

    Tier 1 Capacity
    248
    270
    293
    315
    338
    360
    383
    405

    I have attached an image (I think) that shows what I want. The line is just drawn on top of the chart. you can see the problem with 2 tickets that should be above the line are below it. The Tier 1 capacity means if all 20 agents are on Tier 1 the max tickets we can handle is 405. If 19 are on Tier 1 and 1 is on tier 2 the max # is 383 and so on.

    Any thoughts?

    thanks

    CLIK
    Attached Images Attached Images

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