Stacking data to show same number but different colors

W

wiggy

I am needing to show two sets of data on a stacked bar that will reflect the
total of the denominator. Example. I have 13 cases out of which 1 has a
complication. I want the total on the bar to only reflect 13 but the coloring
of the bars show both data points (13 and 1). Can this be done?
 
J

Jon Peltier

Your stack total must be 13, so your differently formatted stacks have
to be 12 and 1.

Alternatively you could plot 13 and 1 as clustered columns, and set the
overlap to 100.

- 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