Hopefully an easy Pivot Table formating question....

[hobanwashburne]

I would like my results displayed as:

          |Whse         

Channel   |A     |B     

Domestic  |  $$$ |  $$$ 

Export    |  $$$ |  $$$

Where $$$ is the sum of Sales

What I always seem to get is:

Channel   |Whse  |Sum(Sales)

Domestic  |A     |  $$$     

          |B     |  $$$     

Export    |A     |  $$$     

          |B     |  $$$ _   

[jonathandienst · Accepted solution]

Hi

You can click on the Whse header on your chart and drag it up until the red line changes to horizontal.This will place Whse on the top axis.

Hope that helps

Jonathan