Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / March 2004

Tip: Looking for answers? Try searching our database.

Pivot Charts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
desi - 30 Mar 2004 21:28 GMT
All -

Pretty basic question.  I have a pivot table (chart) that is charting
set of issue into four priorities (P1, P2, P3, P4) over time.  We ar
looking for how many of each priority issue we get each week.  Prett
basic.

The pivot table has a 'gand total' (sum) for each week that i
basically = P1+P2+P3+P4.  The problem is that I want this (sum total
to show up on the graph and I cannot get it to do this.  I get a basi
line chart with four lines (1 for each priority). I'd like the fift
line (sum of all prioritys over time) to be graphed as well and
cannot do this.

ANy ideas

-des

--
Message posted from http://www.ExcelForum.com
Debra Dalgleish - 30 Mar 2004 22:20 GMT
I don't know of any way to include the grand total in a PivotChart. You
can 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
> Pretty basic question.  I have a pivot table (chart) that is charting a
> set of issue into four priorities (P1, P2, P3, P4) over time.  We are
[quoted text clipped - 7 lines]
> line (sum of all prioritys over time) to be graphed as well and I
> cannot do this.

Signature

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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.