How To Add A Line To A Stock Chart In Excel. We want to add a line that represents the target rating of 80 over the bar graph. On the insert tab, in the charts group, choose the waterfall or stock chart button and then select the stock group:
Or you can also use alt + f1 to insert a chart. Then, open the insert tab in the ribbon. The stock charts are the third set down.