Resources on Pivot Table & Chart @ ExcelOptimize.Com
Currently Browsing: Pivot table & chart
Posted by Andrian in Pivot table & chart on 02 10th, 2009 | No Comments

Creating a PivotTable Report from Data in an Access Database

One of the beauties of the Excel PivotTable reports is that they are not limited to using data located in a workbook. In fact, it is fairly common to have your data in a database instead. Depending on the configuration of your system and the database drivers installed, you can access data in a wide variety...
Read More
Posted by Andrian in Pivot table & chart on 02 9th, 2009 | No Comments

Using Data from an Existing Data Connection

If you want to base your PivotTable report on an external data source that is already defined, follow these steps: Click the PivotTable button on the Insert ribbon to display the Create PivotTable dialog box (shown earlier in Figure 2-1). Select the Use an External Data Source option, and click the...
Read More
Posted by Andrian in Pivot table & chart on 02 8th, 2009 | No Comments

Using Data from Other Sources

Excel enables you to use data from a variety of other sources for your PivotTable reports.There are two general ways to do this: Link your PivotTable to the external data without importing them into Excel. Import the external data into Excel and then treat them as an Excel list. This section covers...
Read More
Posted by Andrian in Pivot table & chart on 02 7th, 2009 | No Comments

Using Excel Data from Another Workbook

If the data you want to use in your PivotTable are in another workbook, the process is slightly different. You have to specify not only the range in which the data are located but also the name of the workbook they are in.The easiest way to do this is to have both workbooks open; the one where you want...
Read More
Posted by Andrian in Pivot table & chart on 02 6th, 2009 | No Comments

Using Excel Data from the Same Workbook

Perhaps the most common way to create a PivotTable is by basing it on data that already exist in an Excel workbook. The data can be in the same workbook as the PivotTable; this technique was used in Chapter 1. The data can also be in a separate workbook. Things are at their simplest when you are creating...
Read More
Posted by Andrian in Pivot table & chart on 02 5th, 2009 | No Comments

Creating a PivotTable Report with Multiple Columns

The example PivotTable presented in the previous section was just about the simplest PivotTable you can create. It will be useful to go through the process of creating a somewhat more sophisticated PivotTable report, one that has multiple columns as well as rows. The data you will use is shown in Figure...
Read More
Posted by Andrian in Pivot table & chart on 02 4th, 2009 | No Comments

Creating a PivotChart

A PivotChart is nothing more than a standard Excel chart created from the data in a PivotTable report. In fact there are a few features in PivotCharts that you will not find in charts based on other data—that is, data not in a PivotTable. For the most part, however, a PivotChart is like any other Excel...
Read More
Posted by Andrian in Pivot table & chart on 02 3rd, 2009 | No Comments

Using the PivotTable and PivotChart Wizard

Before Excel 2007 (the current version of Excel), you used the PivotTable and PivotChart Wizard to create PivotTables. Even though Excel 2007 provides a new and simpler way to create PivotTable, as described in the previous sections, the PivotTable and PivotChart Wizard is still available. Some people...
Read More
Posted by Andrian in Pivot table & chart on 02 3rd, 2009 | No Comments

Using the PivotTable and PivotChart Wizard

Before Excel 2007 (the current version of Excel), you used the PivotTable and PivotChart Wizard to create PivotTables. Even though Excel 2007 provides a new and simpler way to create PivotTable, as described in the previous sections, the PivotTable and PivotChart Wizard is still available. Some people...
Read More