software

Hi All,

I must be missing something simple, but I've searched the site and looked
around and can't figure this out.

I have a pivot table with one row header, one column header, and a data
field. There is a Grand Total column for the row information.

This Grand Total does not transfer to my PivotChart of the PivotTable as a
data series. I was under the impression the Grand Total would transfer as a
separate series. I can't find any info on this.

Am I crazy?

Thanks.

The Grand Total doesn't appear in a pivot chart. You could create a
normal chart, based on the pivot table, and include the totals in that.

On Jon Peltier's site, there are instructions for creating a normal
chart from pivot data:

www.peltiertech.com/Excel/Pivots/pivotcharts.htmDominic wrote:
gt; Hi All,
gt;
gt; I must be missing something simple, but I've searched the site and looked
gt; around and can't figure this out.
gt;
gt; I have a pivot table with one row header, one column header, and a data
gt; field. There is a Grand Total column for the row information.
gt;
gt; This Grand Total does not transfer to my PivotChart of the PivotTable as a
gt; data series. I was under the impression the Grand Total would transfer as a
gt; separate series. I can't find any info on this.
gt;
gt; Am I crazy?
gt;
gt; Thanks.--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlThanks again Debra.quot;Debra Dalgleishquot; wrote:

gt; The Grand Total doesn't appear in a pivot chart. You could create a
gt; normal chart, based on the pivot table, and include the totals in that.
gt;
gt; On Jon Peltier's site, there are instructions for creating a normal
gt; chart from pivot data:
gt;
gt; www.peltiertech.com/Excel/Pivots/pivotcharts.htm
gt;
gt;
gt; Dominic wrote:
gt; gt; Hi All,
gt; gt;
gt; gt; I must be missing something simple, but I've searched the site and looked
gt; gt; around and can't figure this out.
gt; gt;
gt; gt; I have a pivot table with one row header, one column header, and a data
gt; gt; field. There is a Grand Total column for the row information.
gt; gt;
gt; gt; This Grand Total does not transfer to my PivotChart of the PivotTable as a
gt; gt; data series. I was under the impression the Grand Total would transfer as a
gt; gt; separate series. I can't find any info on this.
gt; gt;
gt; gt; Am I crazy?
gt; gt;
gt; gt; Thanks.
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

I still don't see how to add the grand totals by creating a normal chart.
Does anyone have more detailed information?

quot;Debra Dalgleishquot; wrote:

gt; The Grand Total doesn't appear in a pivot chart. You could create a
gt; normal chart, based on the pivot table, and include the totals in that.
gt;
gt; On Jon Peltier's site, there are instructions for creating a normal
gt; chart from pivot data:
gt;
gt; www.peltiertech.com/Excel/Pivots/pivotcharts.htm
gt;
gt;
gt; Dominic wrote:
gt; gt; Hi All,
gt; gt;
gt; gt; I must be missing something simple, but I've searched the site and looked
gt; gt; around and can't figure this out.
gt; gt;
gt; gt; I have a pivot table with one row header, one column header, and a data
gt; gt; field. There is a Grand Total column for the row information.
gt; gt;
gt; gt; This Grand Total does not transfer to my PivotChart of the PivotTable as a
gt; gt; data series. I was under the impression the Grand Total would transfer as a
gt; gt; separate series. I can't find any info on this.
gt; gt;
gt; gt; Am I crazy?
gt; gt;
gt; gt; Thanks.
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;