<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html><head>
<link href="HA010346322052.aspx_files/Ont.css" rel="stylesheet"><link href="HA010346322052.aspx_files/css_002.css" rel="stylesheet"><script src="HA010346322052.aspx_files/oo.js" type="text/JavaScript" language="JavaScript"></script><link href="HA010346322052.aspx_files/css_004.css" rel="stylesheet"><link href="HA010346322052.aspx_files/css_003.css" rel="stylesheet"><link href="HA010346322052.aspx_files/css.css" rel="stylesheet">
<script language="javascript">
var strShow = '显示';
var strHide = '隐藏';
var strRtl = '';
</script>
<style type="text/CSS">
.ACICollapsed
{
display: none;
}
.ACECollapsed
{
display: none;
}
</style>
<script>
function go(url)
{
window.open(url, "_self");
}
function OpenInNewWindow(url)
{
go(url);
}
</script><title>“数据透视表”报表 101 - Excel - Microsoft Office Online</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="MS.LOCALE" content="zh-CN">
<script type="text/JavaScript" language="JavaScript">
<!--
var L_UNDEFINED_TEXT = "“帮助”找不到此内嵌定义。";
function InlineDefNotFound() { alert(L_UNDEFINED_TEXT); }
function AppendPopup(oSource, sPopup)
{
InitializeGlobalData();
if (typeof(allDivsInPage) == 'undefined' || null == allDivsInPage) return;
var theDiv = allDivsInPage['divInlineDef_' + sPopup];
if (typeof(theDiv) == 'undefined' || null == theDiv)
{
InlineDefNotFound();
return;
}
if (theDiv.style.display.toUpperCase() != 'INLINE')
theDiv.style.display = 'inline';
else
theDiv.style.display = 'none';
}
//-->
</script>
<script language="javascript">var strAssetVersion = '0';var strGoDisplayCountOK = "剩余字符: {0}";var fDisableCounter = false;var fDisableCounterFirst = true;var fWasLastCountOver = false;var fIsSimpleFeedbackWiz = false;var fIsOn2Lines = false;var strGoDisplayCountOver = '您输入了 {0} 个字符。请输入不超过 {1} 个字符。';var strGoDisplayCountOverStar = '* ';var strErrorCommentTooLong = '您输入的文本太长。请输入少于 650 个字符。';var iFeedbackWizStarRated = 0;var iRvasap = 0;var fFeedbackWizJustRated = false;var strYouAreNotOnlineErrMsg = '您没有联机。';var strPageAssetId = 'HA010346322052';var strFeedbackPageUrl = 'http://office.microsoft.com/assistance/fbk.aspx';var strPageLoggingParams = 'CTT=98&Origin=HA010346322052';var strCommentOnThisTemplateLnk = 'http://office.microsoft.com/zh-cn/suggestions.aspx?AssetID=HA010346322052&Type=0&Rating=0';var strCannotSubmitFeedbackErrmsg = '无法提交您的反馈。';var rgStrClickToRate = new Array(5);rgStrClickToRate[0] = '单击可打分: 1 (最多 5 星)';rgStrClickToRate[1] = '单击可打分: 2 (最多 5 星)';rgStrClickToRate[2] = '单击可打分: 3 (最多 5 星)';rgStrClickToRate[3] = '单击可打分: 4 (最多 5 星)';rgStrClickToRate[4] = '单击可打分: 5 (最多 5 星)';var rgStrYouRated = new Array(5);rgStrYouRated[0] = '您的评分: 1 (最多 5 星)';rgStrYouRated[1] = '您的评分: 2 (最多 5 星)';rgStrYouRated[2] = '您的评分: 3 (最多 5 星)';rgStrYouRated[3] = '您的评分: 4 (最多 5 星)';rgStrYouRated[4] = '您的评分: 5 (最多 5 星)';</script> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="CreationDate" content="01/01/99"><meta name="DCSext.oo_source" content="Web"><meta name="DCSext.oo_ul" content="zh-CN"><meta name="DCSext.oo_offver" content="Other"><meta name="DCSext.oo_assetid" content="HA010346322052"><meta name="WT.cg_n" content="excel"><meta name="DCSext.oo_market" content="zh-CN"><meta name="WT.ti" content="%e2%80%9c%e6%95%b0%e6%8d%ae%e9%80%8f%e8%a7%86%e8%a1%a8%e2%80%9d%e6%8a%a5%e8%a1%a8+101"><meta name="DCSext.oo_bc" content="%e4%b8%bb%e9%a1%b5%3e%e4%ba%a7%e5%93%81%3eExcel%3eExcel+2002+%e5%b8%ae%e5%8a%a9%e5%92%8c%e6%93%8d%e4%bd%9c%e6%96%b9%e6%b3%95%3e%e6%95%b0%e6%8d%ae%e9%80%8f%e8%a7%86%e8%a1%a8%e5%92%8c%e9%80%8f%e8%a7%86%e5%9b%be"></head><noscript>
<STYLE TYPE="text/CSS">
.ACICollapsed
{
display: inline;
}
.ACECollapsed
{
display: block;
}
</STYLE>
</noscript><body> <script type="text/javascript" src="HA010346322052.aspx_files/broker.js"></script> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tbody><tr style="padding-bottom: 10px;" align="center"> <td> <div class="cdBodyDiv"> <!-- BUILD VER: 12.0.5543.1000 --><!-- LLCC: zh-CN --><div id="cdlog"><div id="cdsitemaptop" class="cdsitemap"><a href="http://office.microsoft.com/zh-cn/worldwide/default.aspx" style="text-decoration: none;"><img src="HA010346322052.aspx_files/globe.gif" alt="单击此处切换到其他 Office Online 全球网站" title="单击此处切换到其他 Office Online 全球网站" align="absmiddle" border="0"> 中国</a><span style="font-weight: normal;"> (<a href="http://office.microsoft.com/zh-cn/worldwide/default.aspx">更改</a>)</span> | <span><a href="http://r.office.microsoft.com/r/rlidMScomLinks?p1=home&clid=zh-CN">所有 Microsoft 站点</a></span></div><br style="clear: both;"></div><div id="cdheadbg"><div id="cdlogotop"><a href="http://office.microsoft.com/zh-cn/default.aspx" title="Microsoft Office Online"><img src="HA010346322052.aspx_files/logooffice.gif" alt="Microsoft Office Online" title="Microsoft Office Online" border="0"></a></div><div id="cdsignin" class="cdsignincopy">登录我的 Office Online (<a href="http://office.microsoft.com/search/redir.aspx?assetid=HA101694052052&CTT=97&Origin=HA010346322052">这是什么?</a>) | <a id="SignIn" href="https://services.office.microsoft.com/passport/redirect.aspx?sign=in&AssetID=EC101181702052&CTT=5&Origin=HA010346322052&cb=mu%3dhttp://office.microsoft.com%2fzh-cn%2fexcel%2fHA010346322052.aspx%3fpid%3dCH010714012052&lc=2052&ru=http%3a%2f%2foffice.microsoft.com%2fzh-cn%2fexcel%2fHA010346322052.aspx%3fpid%3dCH010714012052"><b>登录</b></a></div><br style="clear: both;"><div class="cdHeaderBorder"></div></div><div class="cdcontainermaster"><div class="cdcontainer"><div id="cdnavcontainer"><div id="cdnavcont"><div id="cdnavheader"><ul><li><a accesskey="1" href="http://office.microsoft.com/search/redir.aspx?assetid=FX100647102052&CTT=97&Origin=CL100570552052&pid=CL100569832052"><span>主页</span></a></li><li id="current"><a href="http://office.microsoft.com/search/redir.aspx?assetid=FX100487412052&CTT=97&Origin=CL100570552052&pid=CL100571082052"><span>产品</span></a></li><li><a href="http://office.microsoft.com/search/redir.aspx?assetid=FX100485362052&CTT=97&Origin=CL100570552052&pid=CL100605172052"><span>帮助和使用方法</span></a></li><li><a href="http://office.microsoft.com/search/redir.aspx?assetid=FX101321102052&CTT=97&Origin=CL100570552052&pid=CL100570422052"><span>下载</span></a></li><li><a href="http://office.microsoft.com/search/redir.aspx?assetid=FX101321032052&CTT=97&Origin=CL100570552052&pid=CL100570202052"><span>剪贴画</span></a></li><li><a href="http://office.microsoft.com/search/redir.aspx?assetid=FX100595492052&CTT=97&Origin=CL100570552052&pid=CL100632982052"><span>模板</span></a></li></ul></div><br style="clear: both;"></div><div id="cdribbon" class="cdSubwebBgColor"><table border="0" cellpadding="0" cellspacing="0" width="950"><tbody><tr valign="top"><td class="cdribtopl" width="2"> </td><td class="cdribtopc" width="946"><div></div></td><td class="cdribtopr" width="2"></td></tr><tr height="79" valign="middle"><td class="cdribmidl" width="1"><div></div></td><td class="cdribmidc" width="946"><div style="padding-top: 1px;"><table class="cdribbontext" border="0" cellpadding="0" cellspacing="0"><tbody><tr valign="top"><td width="2"> </td><td width="414"><div style="border: 1px solid rgb(219, 230, 244);"><t