As you can probably guess, this chart will show the daily high, daily low and the daily close price over time in our chart. The first chart we are going to look at is the High Low Close chart. The title of each of the stock charts in Excel tell us in the name, what exactly it is the chart will show. Watch related video on YouTube Now High Low Close (HLC stock charts in Excel) You can copy and paste this data into a spreadsheet and follow along with the article. We are going to use this data to create each of the 4 stock charts available in excel. The below set of data shows the daily trading information for Bitcoin. Excel offers 4 stock charts and to use these, you must have the right sets of data available and you must select the columns in the right order. They allow you see high and low values over time, along with opening and closing values in the one chart. Assets such commodities, stocks and cryptocurrencies. Stock charts are a specific chart used to track the changes in price of traded assets.

Power trend lines in excel 2016