Instead of using the basic color legend, you can create your own as a work sheet. Here I wasn't using a dynamic field, but if you put the dynamic field in place being used on the bar chart, you can get the desired result I believe. If you can share an excel file or workbook I'd be happy to mock up the example if I'm not making sense.
I have attached the workbook here. Can you please help?
You need to export a packaged workbook (.twbx) so the data is present.
Also, I do not have version 9, so the best I'll be able to give you is screenshots on how to accomplish it.
Sorry, I have attached packed Workbook. Sure, thank you so much.
Based on what I think you are going for, once I got my hand on the workbook, I think this is the solution you need. I did two values you show you the idea so you can continue the work from there.
I created a column called Decode (cal it what you like) with the calculation of this:
If [Pviot Name] = 'Eng' Then
If [Pviot Value] = 0 Then 'Less Engaged'
Elseif [Pviot Value] = 1 Then 'Somewhat Engaged'
ElseIf [Pviot Value] = 2 Then ' Engaged'
Elseif [Pviot Value] = 3 then 'Very Much Engaged'
Else if [Pviot Name] = 'Dif' Then
If [Pviot Value] = 0 Then 'Less Difficult'
Elseif [Pviot Value] = 1 Then 'Somewhat Difficult'
ElseIf [Pviot Value] = 2 Then 'Difficult'
Elseif [Pviot Value] = 3 then 'Very Difficult'
When applied to the viz, you get the following result:
Hope this helps
Great, it works awesome. Thank you very much, Mark!