+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    10-24-2007
    Posts
    28

    Pivot chart query

    I have a worksheet that displays requests for projects. There are two types of requests that are received "on time" and "late". I have produced a pivot table and chart showing these requests by location (what country sent them) and month. There is an SLA target of 70% of all requests to be received on time (no more than 30% should be late, but it happens).

    I was wondering would it be possible to show this line somehow on the graph. So the graph will be a line graph and will show the "on time requests", l"ate requests" and a "target" line for requests. Could you let me know if this is possible.

    Thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    Posts
    632
    I think this site might help:

    http://peltiertech.com/Excel/Charts/AddLine.html
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved

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.2.0