在Excel 2010中添加总计线以透视图表 [英] Add totals line to pivot chart in Excel 2010

问题描述

我有一个非常简单的数据透视表，它基本上总结了所有数据记录的时间，并将其与月份相关联，作为行标签，并可作为列标签计费/不计费。数据透视表实际上显示了一个总计列，它是可结算的小时数和不可收费的小时数的总和。

I have a very simple pivot table that basically sums the hours of all the data records and pivots them with month as a row label and billable/non-billable as a column label. The pivot table actually shows a totals column which is the sum of billable hours and non-billable hours by month.

我创建了一个表示数据的枢纽图表，包括可收费的小时和非计费小时的线路，但由于某种原因，我无法获得显示总时数的第三行。数字存在于我的数据透视表中，但我不知道如何使这些数据点在图表上进行图形化。根据我的研究，似乎一个计算的领域可能会做的伎俩，但这是令人沮丧的 - 我讨厌添加一个计算字段来计算已经显示在数据透视表中的值（虽然我会这样做，如果我不得不 - 也不能得到这个工作）。任何建议？

I created a pivot chart to represent the data, and it includes lines for billable hours and non-billable hours, but for some reason I can't get a third line to show the total hours. The numbers exist in my pivot table, but I'm just not sure how to get those data points to graph on the chart. Based on my research, it seems like a calculated field might do the trick, but that's frustrating--I hate to add a calculated field to calculate a value that's already displayed in the pivot table (though I'd do that if I had to--just couldn't get that to work either). Any suggestions?

推荐答案

除非您需要PivotChart的灵活性，否则您的PivotTable值将使用简单的单元格引用，然后使用新范围的值创建一个常规图表。

Unless you need the flexibility of a PivotChart, bring your PivotTable values down into regular cells below the table using simple cell references, then create a regular chart using the values of the new range.

例如，如果数据透视表结果在单元格中，例如A1-E5（包括行和列标签）以及总计总数，则将结果拖至单元格F7-E10。也就是说，F7公式将为= A1等。然后，使用范围F7-E10插入新的图表。

For example, if pivot table results are in cells, say, A1-E5, including row and column label and the Grand Total Line, then pull the results down to cells F7-E10. That is, F7 formula will be "=A1", etc. Then, insert the new chart using range F7-E10.

这篇关于在Excel 2010中添加总计线以透视图表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！