Spreadsheets Tutorial: Visualizing the price evolution

Want to learn more? Take the full course at https://learn.datacamp.com/courses/financial-analytics-in-spreadsheets at your own pace. More than a video, you'll learn hands-on coding & quickly apply skills to your daily work. --- At this point, you have the minimum and maximum historical prices together with the dates at which they occurred. What is missing is a visualization of historical prices, to get an idea about the dynamics of the time series. A useful tool that traders and financial analysts use to visualize and understand the past movements of stock prices is a line chart. A line chart represents a series of values as points, called "markers", connected by linear segments. The result is a line plot showing the values of the historical prices during the period under analysis. The time is represented on the horizontal axis, in chronological order, from left to right. The price level is displayed on the vertical axis. Building a line chart with spreadsheets is easy. First, you select the range of cells that you want to display. Next, you click on "Insert" and then on "Chart". You should already see a line chart because the software will suggest to you the most appropriate graph for the data you selected. If not, in the "Chart editor", select "Line chart" under the section "Chart type", and you're done. The "Chart editor" is like the palette for a painter. You can use it to improve your graph and make it more detailed, nicer, and more informative. The "Chart editor" is composed of two sections. The first section is "Setup", where you can add series to your graph. For example, you can include historical prices of other stocks for comparison purposes. Or you can display the dates corresponding to each price on the horizontal axis. The second section is "Customize" where you can modify the titles, the legend, and other graphical parameters. Let's say that you want to improve this chart and make it more explanatory. First, you decide to add the dates on th