Is there a way to tie certain colors to certain values in a stacked bar plot? I'm creating several bar plots of the same data divided by a variable not represented on the graphs. The stacked bar plot represents the proportion of a variable valued either "yes" or "no" at different time periods (each bar is a different time period). I'm encountering trouble because some plots have only data with a value of "yes" in the first time period, and others have only data with a value of "no" in the first time period (and others have both values in the same time period). Therefore, efforts to order how colors are assigned to stacked parts of bars aren't working, since the first occurring value isn't the same in every plot. I could just create each plot separately so I can change how the colors are ordered for each plot, but I'm trying to use a macro. Is there a way to ensure "yes" is always blue and "no" is always red, regardless of whether only yes, only no, or both are represented in the first stacked bar on a plot? Thanks!
... View more