Hopefully this is an example of what your trying to achieve. I've also
included a file that can be downloaded.

http://www.cellmatrix.net/index.php/...de_zero_values

http://cellmatrix.net/index.php/site/downloads/

--
John Mansfield
http://cellmatrix.net





"widman" wrote:

I have an excel chart that summarizes the days I spend in the year in any of
28 different markets, although each year I probably only work 6 to 10 of
those markets. Then I have a pie chart that puts it in perspective. I want
the pie chart to show only the markets with values over 0.
How can I get the pie chart to ignore the markets with 0 visits? It wants
to show all 28, superimposing all the names on top of each other.