Figure 3-39 Excel 2007 charts formatting the data series lines
USS Code 39 Maker In Visual C#
Using Barcode printer for Visual Studio .NET Control to generate, create Code 3 of 9 image in VS .NET applications.
ANSI/AIM Code 39 Creator In .NET Framework
Using Barcode generator for ASP.NET Control to generate, create Code 3/9 image in ASP.NET applications.
Figure 3-40 shows a final and really interesting Excel 2007 chart feature the ability to quickly mark up a multiple data series line chart to show relative differences between the series
ANSI/AIM Code 39 Encoder In .NET Framework
Using Barcode creation for .NET framework Control to generate, create Code39 image in .NET framework applications.
Draw Code-39 In Visual Basic .NET
Using Barcode creation for .NET framework Control to generate, create Code 39 Full ASCII image in VS .NET applications.
1 Click the Up/Down Bars option in the Analysis menu group, on the Ribbon
UPC A Decoder In VB.NET
Using Barcode recognizer for .NET framework Control to read, scan read, scan image in Visual Studio .NET applications.
Painting Bar Code In Visual Studio .NET
Using Barcode generation for Reporting Service Control to generate, create barcode image in Reporting Service applications.
menu Layout tab 2 Click the Up/Down Bars option on the pop-up menu to show the bars The result of the up/down bars would be hard to explain without being able to see it in a chart such as Figure 3-40 Note that while it only works on a line chart, it certainly adds a unique visual element of analysis that makes it easy to see the
GS1 - 13 Decoder In None
Using Barcode decoder for Software Control to read, scan read, scan image in Software applications.
Recognize Data Matrix In C#
Using Barcode recognizer for .NET Control to read, scan read, scan image in .NET applications.
Microsoft Office 2007 Business Intelligence
Printing Bar Code In .NET Framework
Using Barcode encoder for ASP.NET Control to generate, create barcode image in ASP.NET applications.
Making Code 3/9 In None
Using Barcode printer for Office Excel Control to generate, create ANSI/AIM Code 39 image in Excel applications.
Figure 3-40 Excel 2007 charts up/down bars for data differentiation
Barcode Creator In VB.NET
Using Barcode printer for VS .NET Control to generate, create barcode image in .NET applications.
Linear 1D Barcode Generator In Java
Using Barcode encoder for Java Control to generate, create Linear 1D Barcode image in Java applications.
parallel data points that have the greatest differences in value between the two data series This kind of feature exploration is typical of working with Excel 2007, and using the features with real-world spreadsheets can really set the spreadsheets apart so that they become presentations that accurately and quickly convey a data story to audiences!
Recognizing UPC A In Visual C#.NET
Using Barcode recognizer for .NET framework Control to read, scan read, scan image in .NET framework applications.
Bar Code Recognizer In C#.NET
Using Barcode recognizer for VS .NET Control to read, scan read, scan image in .NET framework applications.
Scan Code 128 Code Set A In None
Using Barcode scanner for Software Control to read, scan read, scan image in Software applications.
Creating EAN13 In Java
Using Barcode creation for Java Control to generate, create EAN-13 Supplement 5 image in Java applications.
Excel and External Data: Files, Databases, Cubes, and Data from the Internet
Draw Code 128C In .NET
Using Barcode generator for Visual Studio .NET Control to generate, create Code-128 image in Visual Studio .NET applications.
1D Barcode Creation In VB.NET
Using Barcode generator for VS .NET Control to generate, create Linear 1D Barcode image in .NET framework applications.
IN THIS CHAPTER
ANSI/AIM Code 39 Encoder In C#
Using Barcode maker for .NET framework Control to generate, create Code-39 image in .NET applications.
Code 128 Code Set B Maker In None
Using Barcode generator for Office Word Control to generate, create Code 128 Code Set A image in Word applications.
What Is an External Data Connection Importing Data from a Text File into Excel 2007 Importing Access Data into Excel 2007 Importing Oracle Data into Excel 2007 Importing SQL Server Data into Excel 2007 Importing SQL Server OLAP Data into Excel 2007 Connecting Excel to the Internet with Web Queries
Microsoft Office 2007 Business Intelligence
he real power of Excel is realized when it s connected to external data This chapter explores in some detail the various data sources that are supported from within Excel 2007 using Office Data Connections As an example, Excel s Text Import Wizard is so powerful that database experts often use it to bring miscellaneous data files into an Excel table where it s easy to work with data You ll find out how to connect to Access, Oracle, and SQL Server; to OLAP cubes, which are a great source of hierarchically organized data; and even to web site data on the Internet using an Excel Web Query The following topics will be covered in this chapter: Turning your les into Excel data, and Of ce trusted locations Converting MS Access, Oracle, and SQL Server les into Excel Multidimensional SQL Server OLAP cubes and Excel Converting web queries from the World Wide Web into Excel
For further research on this topic, go to http:// blogsmsdncom/excel
Technology Positioning Statement
Excel 2007 Office Data Connections (ODCs) offer a great way to connect the new features in Excel to all kinds of external data ODCs can be shared and reused among Excel users to look at data from SQL Server or Access, Oracle, or DB2, and the Text Import ODC has a really good Text Import Wizard Once someone has connected to external data, it s easy to format and sort it in an Excel table or PivotTable The new million row capability of Excel will likely encourage users to connect Excel to all kinds of data they may have in their organizations, and it positions Excel 2007 to continue as the most popular data analysis tool in the world Sean Boon, Microsoft Excel Team
4: Excel and External Data: Files, Databases, Cubes, and Data from the Internet
What Is an External Data Connection
Excel provides the ability, out of the box, to connect to data outside of Excel Realizing this opens a whole new world to Excel users, since you can then connect to almost any data lying around in files or to database servers in your organization if you have permission to do so Excel is one of the best ways to connect to OLAP cubes as well (we ll see what this looks like later in the chapter) When you connect to external data from within Excel, the external data can easily be imported into an Excel spreadsheet, where all the great tools of Excel 2007 can be used to analyze and arrange the data In fact, Excel can connect to data on the Internet, and we ll show how to do this in the chapter as well Imagine, connecting to the entire world s data available to you in Excel 2007, which can hold one million rows in a spreadsheet! Importing data into Excel typically results in an Excel table, which provides a way to keep your data in a coherent list format on an Excel spreadsheet This list format is really somewhat like a database table, if you are familiar with database terminology It organizes the data into labeled columns with drop-down datafiltering controls that allow you reduce the data being displayed and to sort it in organized ways Tables are likely to be a popular tool with Excel 2007, since spreadsheets can hold one million rows in 2007, and with all that data ending up in Excel, it really helps to be able to easily turn it into columns that control the data display Excel tables provide a list of all data elements, whereas Excel PivotTables provide aggregates of data elements PivotTables are not appropriate for all situations, and in fact they are somewhat specialized with their automatic cross-tab behavior (although PivotTables are the norm when connecting to OLAP cubes, as we ll see in this chapter) Both Excel tables and PivotTables can handle large data sets and support slicing and dicing of data in a business intelligence sense, and both work with conditional formatting and charting The following illustration shows an example of an Excel 2007 PivotTable, with an External Connection to a SQL Server Analysis Services cube This chapter will explore the steps used to create this example PivotTable