The wikiHow Tech Team also followed the article's instructions and verified that they work. I mean it plotted 2 points at the Y value of 100. If so, skip this step. Make sure you include column headers if you have them. How do I give my graph made in MS Excel a zoomed in view? Changing the Chart title based on the Conditions – Step 1:Link a Cell to the Chart Title. The above article may contain affiliate links, which help support How-To Geek. Here we want to format the entire row based on Delivery status, whose value is equal to Pending. How do I create a graph that appears in an Excel cell after I click on that particular cell? Select the Data Labels box and choose where to position the label. Copy the formula from cell B9, into cells C9-M9. This will add another line to your chart for that target number or set of numbers. How do I plot the graph of growth percentages in MS Excel? This value is also negative. Because A,B,C,D,E, and F, mean this: (A:2000->B:2001->C:2002->D:2003->E:2004->F:2005.). For example if the number is 1 and the data series is in column A the range of the chart should be A1:A100. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d1\/Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-5.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-5.jpg","bigUrl":"\/images\/thumb\/d\/d1\/Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-5.jpg\/aid1146296-v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-5.jpg","smallWidth":460,"smallHeight":348,"bigWidth":"728","bigHeight":"551","licensing":"