Removing Blank cells from chart.

Hi,

I have posted this question in main forum but may be better suited here.

My Table has has data taken from a source that can be from 1 to 1000 names. A macro removes the duplicates band the chart then shows the data as a bar chart. Howeve rit is plotting the blank cells , so if the data has only 10 names it plots many blanks. Any Idea how to do this so as to not show blanks in chart (I do not have option to remove blanks in the table)

Thanks