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.)