Filter Legend for Only Relevant Values

Question & Answer
1

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!

image
image1890×551 115 KB

2

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:

image
image1905×483 67.8 KB