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 / September 2006

Tip: Looking for answers? Try searching our database.

Pivot Chart--I want total average, not sum of averages

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jason McDermott - 01 Sep 2006 12:59 GMT
I've scoured the internet for an answer to this and still no luck.
I want my pivot chart to display the overall average labor time (y-axis) for
every order (x-axis) that ALL customers have placed. If I tell Excel to plot
average labor, it averages the orders for each customer and then stacks those
averages, essentially summing the averages. This is useless.
Here's the kicker: when I look at the pivot TABLE, the grand total column is
doing it the right way! It sums all data and takes a count of all data and
divides. It knows a grand total column that is the sum of averages is
useless. Is there a way to plot the grand total column (which should be the
default for averages anyway)?
(Yes, I know I could copy the GT column into another sheet and use a regular
chart. That's what I'll probably end up doing.)
Rob Hick - 01 Sep 2006 15:39 GMT
> I've scoured the internet for an answer to this and still no luck.
> I want my pivot chart to display the overall average labor time (y-axis) for
[quoted text clipped - 8 lines]
> (Yes, I know I could copy the GT column into another sheet and use a regular
> chart. That's what I'll probably end up doing.)

Pivotcharts are evil for a number of reasons - this being one of them.
I generally avoid them and use normal charts off the back of the pivot
tables.  To do this you need to avoid certain doing certain things and
compile your charts in a certain way.  There are various postings about
how to do it but in summary:

- Draw a blank chart by selecting an empty cell away from the pivot
table; clikc the insert chart button and then immediately click finish.
- The most secure way is then to add in the data series manually by
using the 'source data' dialog.
- You can drag and drop the series you want from the pivottable BUT you
must be careful not to select the header row, if you do it will
recognise the pivot table and draw a pivotchart.  So only select the
data and then name the series yourself.
- If you find that the chart suddenly turns in to a pivotchart, undo
what you did and do it a different way - once the chart is built it
won't suddenly change; it's only the initial setup that is the tricky
thing.
Jason McDermott - 01 Sep 2006 16:46 GMT
Thanks, Rob--I guess
Not really the answer I wanted, but at least I know I'm not alone.
Rob Hick - 01 Sep 2006 18:20 GMT
> Thanks, Rob--I guess
> Not really the answer I wanted, but at least I know I'm not alone.

when you're working with PivotCharts, you rarely get what you want!
They are probably the most inflexible part of excel, certainly that
I've come across.  As I say - don't use them, then you won't ever be
disppointed.
 
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



©2009 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.