View Single Post
  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

The easiest way for me is to select the bar that you want at the bottom. In
the command line, you should see something like this:

=SERIES(Sheet1!$D$1,,Sheet1!$D$2:$D$7,4)

Change the 4 at the end of the series to 1 and it will be at the bottom of
the stack.

"Gian" wrote in message
...
The order of the data plot by the stacked bar (y-axis) is opposite from

the
data range I selected. How can I change that so the order is same as the

data
I hace in the worksheet?