Microsoft Office Tutorials and References
In Depth Information
Figure 5-34. Setting up the SSS Application ID for ODC
in the import Data window, choose pivottable and, for the existing worksheet, leave the
default selection (=Sheet1!$a$1) as shown in Figure 5-35 . Click on the properties button to
view and alter connection settings, and then click OK to close the window.
Figure 5-35. Import Data wizard window
■ Unlike earlier version of excel, in excel 2013 users can create pivotCharts without having to include a pivottable.
You can directly choose the pivotChart option and build charts.
the excel sheet will prepopulate the pivottable and pivotChart, as shown in Figure 5-36 . the worksheet includes
the pivottable, pivotChart, and pivottable Field list. You use the pivottable field list to select the fields for the
pivottable and the pivotChart.
Search JabSto ::