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.
posted by Rad_Boy to Science & Nature (6 answers total) 2 users marked this as a favorite
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!