Creating a chart using selected cells from worksheet

[Zilla]

I would like to create a pie chart using selected amounts on a
worksheet. The work sheet is set up with columns for each month. In
each colum there are 8 totals with blank cells between each total. When
I do the pie chart it includeds the blanks therefore making a pie chart
with a section for the blank area. How can I just select the totals
from one column?
I have tried holding down shift and clicking and holding crtl but it
still selects all cells in between.

thanks

 

[Don Guillett]

Hide the rows/columns

 

[Zilla]

Ok that works. Is there a way I can add in the names of the totals
along with the amounts in each pie section. ex. 8 sections one pie
chart 8 different names.