Stacking data to show same number but different colors

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?

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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



wiggy wrote:
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?