How can I add straight "limit" lines to simple Excel X/Y graphs?
April 14, 2014 9:02 AM Subscribe
I'm using Excel 2010 and I'm making several x/y scatter graphs to plot QA results. I want to show on the graphs an upper and lower allowed limit for the data.
Each data plot will have it's own graph with less than ten data points which use a numeric value for the "Y" data point, and a date value for the "X" axis. The graphs I have made in Excel 2010 are easy to make and look good. Now how do I add those limit lines? The value for each line must be a function of some data points in the spreadsheet.
I would have thought that by now Excel would have made this easy!