I have a spreadsheet tracking a stock's weekly performance and want to effectively graph it as described below.
My spreadsheet is setup as follows:
Column A: Date of last trading day of the week - usually a Friday - format; Short Date (mm/dd/yyyy).
Column B: Closing price of the stock for that...