Excel 2007 pivot table choose vertical axis 1

[mtdew]

I have a simple pivot table graph I want to create. I have the date, listing price, sold price and DOM. The graph always places the dates (grouped by quarters) on the horizontal axis and I want it on the vertical axis. How can I change this?

 

[SkipVought]

Hi,

Switch the data from ROW to COLUMN or vis versa in the PivotTable.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[mtdew]

Although I swapped the row and column items I still have values on the vertical axis.

 

[SkipVought]

Try Chart Type of BAR.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}