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