Hi there,

For a stacked bar chart (not the 100% stacked bar chart), is there a
way to stack the data within a series and make each series a different
bar within the bar chart, instead of vice versa which appears to be
the Excel default (e.g. In Excel, the highlighted values for a series
become separate bars, and each subsequent series is stacked upon this
preceding series dependent upon the order of the highlighted values)?
If not, can I move around my bars so that some are more adjacent to
particular bars and not so close to others?

If this isn't clear, I've tried to specify my issue below, but it
might make things even more confusing:

I am trying to compare two different series of data (ex. red and blue)
in 3x2 different categories (ex. light red, medium red, dark red,
light blue, medium blue, and dark blue) all in one stacked bar chart.
This should create 6 total bars for each color type, where two bars
are adjacent to each other for each of the light, medium, and dark
categories (ex. the stacked bar for light red would be adjacent to
light blue, and medium red would be next to medium blue etc.). I
should mention that each group (ex. light blue, medium red, etc.) has
5 different values, which are independent across groups, and it is
these values that are being stacked within each bar.

Hope this is clear! If not, sorry for wasting your time.

Thanks,

Hos