Hide legend items in a graph when associated value = zero or blank

hi Ben. this is a little tedious.
1. do up a separate table with formulas to pick up only those values greater than 0. i used an array formula in G2:
=IFERROR(INDEX($C$2:$C$16,SMALL(IF($D$2:$D$16>0,ROW($D$2:$D$16)),ROWS(G$2:G2))-ROW($D$2)+1),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you might get an error or a clearly incorrect answer. Press F2 on that cell and try again.

2. do a VLOOKUP formula in H2:
=IFERROR(VLOOKUP($G2,$C$2:$E$16,3,0),"")

3. this formula below will intelligently pick up the new range i have without the blanks:
=$G$2:INDEX($G$2:$G$16,COUNTIF($G$2:$G$16,">"""))

4. i need to store the formula in step 3 under a Named Range. to do that, press CTRL + F3 -> New. give it a Name & insert the formula of step 3. (shown in screenshot inside file). i named it Prog

5. repeat step 4, give another name for the FTP % & use this formula:
=$H$2:INDEX($H$2:$H$16,COUNTIF($G$2:$G$16,">"""))
it's basically the same formula but changing the column to H. i named it FTP

6. right-click your chart & Select Data. Edit the Legend Entries. change the series values to show the sheet name, exclamation mark & your Named Range for FTP. so mine looks like this:
=Charts!FTP
also in screenshot inside file

7. similarly, right-click your chart & Select Data. Edit the Horizontal Axis. change the series values to show the sheet name, exclamation mark & your Named Range for Program. so mine looks like this:
=Charts!Prog
also in screenshot inside file

fpunzi, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.