G
Guest
I want to make a simple pie chart with 2 colums of data. One column is the
names and the other is the data. However, there are blank spaces in the
columns. Can I get excel to ignore these blanks. Of course they don't show
up in the pie since they have no value but the legend still has a spot for
them. Perhaps it is just a matter of getting them out of the category labels.
apples 50
bannanas 20
oranges 70
grapes 10
The manual way I have used is to only select the cells with data. But if
the data changes and other cells become non-blank then I have to go through
and reselect. The example above is pretty simple. The actual columns are
about 200 cells long with about 10 to 20 non-blank cells in the list. The
colums were created by taking the most significant entries out of two other
columns.
names and the other is the data. However, there are blank spaces in the
columns. Can I get excel to ignore these blanks. Of course they don't show
up in the pie since they have no value but the legend still has a spot for
them. Perhaps it is just a matter of getting them out of the category labels.
apples 50
bannanas 20
oranges 70
grapes 10
The manual way I have used is to only select the cells with data. But if
the data changes and other cells become non-blank then I have to go through
and reselect. The example above is pretty simple. The actual columns are
about 200 cells long with about 10 to 20 non-blank cells in the list. The
colums were created by taking the most significant entries out of two other
columns.