how to make grand total to show up on pivotchart?

R

Rudy Lew

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top