Compare to Total in Pivot Chart

Thanks in advance for anyone's help.

I have a table of sample data that I am attaching. I need to create 2 pivot charts from this data. The first chart will show the average of the department chosen month to month throughout all divisions aka entire company (one line), throughout All Stores in the division of the store (second line), verses this one store (third line)... line can be bars or lines. The second chart will not go as deep to compare to individual stores but it will show the average of the department chosen month to month throughout all divisions aka entire company (one line) vs whatever division is chosen (multiple divisions can be chosen) but plotted separately.

For each of these 2 pivot charts It should plot the Revenue, Expenses, and Labor.

So three layers plotted entire company average for the department, that division average for the department, that store average for the department

Any help with this would be great.

forum.ozgrid.com/index.php?attachment/59560/

Re: Compare to Total in Pivot Chart

Herbds7 Thanks for your response. I will look into PowerPivot to see if this tool can provide the answer. The second chart example that you provided isn't along the same vein I was thinking. I was thinking that for department toy in division 2 you could compare division 2 overall to company overall to a particular store within division 2 or even compare 2 separate stores together in division 2.

Re: Compare to Total in Pivot Chart

I will definitely check out that book.

Thank you.