I have a spreadsheet exported from Access that contains a list of jobs and the time taken to complete each job. I have created a pivottable that gives me the average time taken over each weekly period. Based on that pivottable I have a pivotchart. What I would like to do is display a target line on the pivotchart at a value of 7200 secs (2 hours) so we can see at a glance who is above target and who is below. I cannot see anything in the help files that allows me to do this.
It would be nice to be able to do this in coding as the target is unlikely to change. Any ideas? --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
