A line chart is very useful to visualize data that changes over time. It consists of a set of data points that are connected by a line. The horizontal x-axis typically shows the categories in which the data is divided. The vertical y-axis shows us the values.
This recipe shows how to add a line chart to a dashboard and how to link it to the data in the spreadsheet. Also, we will discuss the components that are similar to the line chart component—Bar chart, column chart, area chart, and stacked charts.
Open a new Dashboard Design file and enter the data into the spreadsheet, as shown in the following screenshot: