From: Rudy Lew Rudy on 5 May 2010 04:10 Hello, I have created a pivot table, overall it look like this: ------------------------------------------- Location Code | (Multiple Items) | -------------------------------------- ----- Sum of Sales Quantity | Category Name | -------------------------------------------- Year | Month | ACER | TOSHIBA | Grand Total | ----------------------------------------------------------------- 2009 | January | 10 | 5 | 15 | | February | 11 | 40 | 51 | ----------------------------------------------------------------- Grand Total | 22 | 45 | 66 | Now when I insert a Pivot Chart based on this PivotTable, and i Put the Category name (Acer-Toshiba) into the "Legend" fields. it shows 2 line of chart normally. Acer line chart, and Toshiba line chart. but how do i make another line in the chart that shows the "Grand total" just as it shows in the pivotTable ? ("grand-total column" line chart) What i mean is, in the pivotTable, the grand total shows up normally, but in the pivotChart, the grand total doesn't show up. How do i make it to appear as an extra line chart? Thank you very much and kind regards
|
Pages: 1 Prev: Microsoft Responds to the Evolution of Online Communities Next: Shrinking Graphs in Excel 2007 |