I am not sure why you would want to do this unless this detailed legend is beside another associated graph. That being said:
- Create 1 worksheet with the color coding,
- Duplicate that sheet.
- remove the color coding.
- Select hide field labels for row.
- shrink sub category as narrow as possible (hover near the right to get the arrow icon)
- right-click the categories, and select format. click the down arrow on font and make it white.
- Create a dashboard and drag the original colored sheet to it. Minimize the sheet, but let the legend be normal size
- drag the second sheet beside the first.
You may want to format the font size on the duplicates sheet.
If you want those colors on the left of categories, you need to combine two sheets. Keep the table in Sheet 1 and create Sheet 2, drag Sub-Categories field into the color and change mark type as Shape. Then you can combine sheets in Dashboard. I am not aware of any way that let you this outcome in same sheet.
One option would be to create one sheet for the label and one sheet for the text table. In your dashboard, place the two side by side so it appears like your example above. The important part would be to make sure the sorting is consistent and any filters match/are synchronized. You can setup actions (if desired) to perform filtering or highlighting when you interact with the colors.
I've attached an example.
Book1.twbx 1.3 MB
You are welcome. Thanks for the "Badge". Appreciated!:)
How do people refer to the use of a dummy calculated field like A, which is assigned a value of 0? I've seen that on other workbooks and I am somewhat mystified. I want to be able to search for other questions/answers with that approach. I don't know the conditions under which I might use dummy calculated fields or the scope of what they potentially offer. I will check out the video link above later.
Thanks in advance for any guidance.