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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks