Stacking data from within a series within a bar chart

  • Thread starter Thread starter Hosley
  • Start date Start date
H

Hosley

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
 
Each point within a series in a bar, column, or line chart correspond to a
different category; points within a series cannot be stacked. You have to
rearrange the data so that items in the same level are in the same series
and items in the same stack are in the same row, then plot series by column.
To get the different colors, and to combine clustered and stacked items, you
should look at the links on this page:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

- Jon
 
Back
Top