Hi,

The pivot chart order is based on the pivot table order of the field being
considered.

Suppose the the data looks like this in the pivot table

Values Field
Row Label Total Sold
A 30
B 12
C 5
D 25
E 37

Open the Filter for the Row Label field and choose More Sort Options, check
Ascending (A to Z) by, open the drop-down below this option and choose Total
Sold, click OK.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"TomC" wrote:

I am using the Pivot Chart Report and the columns are displayed in
alphabetical category order. I desire an arrangement of the categories in
value order (lo - hi) as excel displays the columns in the regular bar
charts. How do I change the sequence of the columns on the Pivot Chart
Report?? Would greatly appreciate any help. Tomc