4 Replies Latest reply on Nov 15, 2017 12:10 PM by Jamie Watts

# Color and shading with 2 dimensions (10.0)

I'm working with a stacked bar graph where I would like to be able to have different colors for each stacked bar and different shades within each stacked bar. I have 1 dimension "Participant" in rows and 3 measures "Value 1", "Value 2", and "value 3", with Measure Values in columns. Currently I have the Measure Names dimension in the color field, which gives me 3 different colors within a stacked bar but every stacked bar has the same 3 colors. I saw this solution for creating shading within a stacked bar, but it requires that the field used for the shading be a measure and not a dimension. However, I would like to sort color between bars by the dimension "Participant" and shading within bars using the Measure Names dimension, which can't be converted to a measure or used in any calculations. Is there any way to achieve shading using a dimension or manipulate the Measure Names dimension into a field?

• ###### 1. Re: Color and shading with 2 dimensions (10.0)

Do you mean something like this (below)?

-- Glenn

• ###### 2. Re: Color and shading with 2 dimensions (10.0)

Sort of. I'd like to make it, for example, be West is shades of blue, South is shades of red, North is shades of green, etc. rather than having shading along a single axis across all of the categories.

• ###### 3. Re: Color and shading with 2 dimensions (10.0)

You probably want Measure Values on Columns, Participant on rows, and both Participant and Measure Names on Color.

For the color piece, drag Participant onto color, and Measure Names onto Detail. Then hover over Measure Names, click the icon next to it, and select the colored circles. The order of these fields matters. Participant above Measure Names means have a unique color for each Participant, and a gradient within that color for each Measure Name. Reversing the order reverses the nested coloring.

1 of 1 people found this helpful
• ###### 4. Re: Color and shading with 2 dimensions (10.0)

Perfect, thank you!