In Excel2007, I have a pivot bar chart with over 20 stacked series. I order
to change the look of the bars, I have to select them all first. I have not
found a way to select more than one series at a time and it makes changing
the shape style very cumbersome.

I have checked the current selection area and the selection pane to no
prevail.

Any clues?
J