-
Book Overview & Buying
-
Table Of Contents
SAP BusinessObjects Dashboards 4.0 Cookbook
By :
The OHLC chart and candlestick chart are both designed to show the movement of a stock price over time. OHLC stands for Open, High, Low, and Close. These four stock price values are illustrated for each time unit.
Both components work in exactly the same way, so you can use both the OHLC chart component and the candlestick chart component for this recipe. The only difference between them is the graphical visualization.
For this recipe, we need some historical stock data. Open your browser and go to http://www.nasdaq.com/ and look for historical quotes on the SAP AG stock.

Select a timeframe of one month and copy-paste the quotes to the spreadsheet of a new Dashboard Design file.

First we need to prepare the data in the spreadsheet. It is now sorted from new to old quotes. As the OHLC Chart component does not enable sorting (see the recipe Sorting series later in this chapter) we have to sort the data ourselves in the spreadsheet...
Change the font size
Change margin width
Change background colour