Custom Chart - Customizing the Legend Values / Displayed Names

I have a custom chart that lists all the counties in our state. When applying the custom chart to data, the legend populates the values. I want the legend to populate the names. Can this be achieved? The first photo shows how the legend is showing counts of the FIPS (counties) values. The second photo shows an example of the county name displayed when hovered (DuPage) which is what I would like the legend to always display. There seems to be few legend options in the Chart Properties for Custom Charts. Any ideas?

Find more posts tagged with

Comments

ST_Superman

I can't think of a way, or fully understand the use case, for getting the legend of this chart to display the county names. In your example, there are at least two counties with a value of 2 and several with one. Are you saying you want to see the legend simply list every county?

Depending on your use case, I would recommend putting either a filter card next to this map or a table card with the name of each county.

What is your ultimate goal in listing out the county names in the legend?

SusieQ

Sorry that I missed your response long ago! I wanted the legend to display only the counties that have a value. For example, "DuPage - 2".

ST_Superman

@SusieQ

I would consider splitting this task over two charts in a dashboard then. Place your custom map on one side and then add a table card that lists the counties along with the value next to it.

SusieQ

That will have to do! Interestingly I just came across this scenario again and in googling found my own question. LOL. It's just too bad, as sharing the card via PowerPoint all the data will be split up. Thanks again!

ST_Superman

@SusieQ

Have you looked into the Domo plugin for Power Point?

SusieQ

Yes, I've used it before; it's been awhile since I've dabbled and I'll have to test it again - I'm publishing the cards to SharePoint via the PowerPoint option.