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:

http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm


Dominic wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks again Debra.


"Debra Dalgleish" wrote:

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:

http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm


Dominic wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

"Debra Dalgleish" wrote:

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:

http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm


Dominic wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html