Filter Legend for Only Relevant Values

Hi All,

Is there a way to filter the Legend on a chart to show only relevant values? Even though most of the categories aren’t showing up on this chart, they are present in the legend, this is super distracting!

Actually… just figured it out. This chart uses a SUMIF calculation. So I added a filter on the chart to filter out anything that is 0 or NULL and that cleared out the extra legend categories. It also made the default colors selected less offensive :slight_smile: