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?
|