show only items with values on chart
 

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.

show only items with values on chart
 

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.

show only items with values on chart
 

Perfect.... thanks

"John Mansfield" wrote:

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.