Stacking data from within a series within a bar chart

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top