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. We will also discuss the components that are similar to the line chart component: bar chart, column chart, area chart, stacked chart, and the Marimekko chart.

Getting ready

Open a new file in SAP BusinessObjects Dashboards and enter the data into the spreadsheet, as shown in the following screenshot:

Note

You can also click on the Line Chart component in the Components browser, move your cursor to the canvas area (the arrow will now change into a cross), and click again. You can use whatever method you prefer.