How to remove #N/A from chart.

[jbailey01]

Hello,
Using this setup https://sites.google.com/site/e90e50fx/home/sort-the-data-on-the-excel-chart I created a chart that would be always sorted descending. The problem is I have a few formulas the create the different Category names. Anything that returns a value for a blank cell is showing up on the chart with a #N/A. I was just curious how I can have anything that has a blank cell not show up on the chart at all. I am using this method for about 20 different charts and I want it to auto update and only using certain categories.


Thank you.

 

[patel45]

can you provide a link to a sample file ?

 

[jbailey01]

can you provide a link to a sample file ?

http://www.filedropper.com/samplefile

 

[jbailey01]

If anyone maybe knows somewhere I can read up on how to make this chart function properly that would be great.


Thanks for reading. I appreciate any help available.

 

[patel45]

see attached http://www.filedropper.com/graphoccurrences