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

Hide the rows/columns

--
Don Guillett
SalesAid Software

"Zilla" wrote in message
ups.com...
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

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.
Don Guillett wrote:
Hide the rows/columns

--
Don Guillett
SalesAid Software

"Zilla" wrote in message
ups.com...
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