View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Selecting multiple series in pivot chart

You can only select one series at a time in any version of Excel.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"johnny" wrote in message
...
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