In this recipe, we will show you how to integrate a real-time news ticker into your dashboard. To set up this connection to an online news website, we will use the Excel XML Maps connection.
Make sure the spreadsheet area has a Developer tab, if you are using MS Excel 2007. If you do not see this tab, skip to the There is more... section of this recipe to set this up. Furthermore, you need a connection to the Internet.
Go to http://www.cnn.com/. At the bottom of this site, you will see an RSS link. You can also go directly to http://www.cnn.com/services/rss/.
Copy the URL of the Top Stories RSS feed http://rss.cnn.com/rss/cnn_topstories.rss.
Open a new Dashboard Design file, go to the Developer tab, and click on Source. The XML Source pane now appears.