show only items with values on chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

widman - 29 Apr 2007 12:40 GMT

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.

Reply to this Message

John Mansfield - 29 Apr 2007 18:06 GMT

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/pie_chart_exclude_zero_values

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

Signature

John Mansfield
http://cellmatrix.net

> 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.

Reply to this Message

widman - 29 Apr 2007 19:42 GMT

Perfect.... thanks

> Hopefully this is an example of what your trying to achieve. I've also
> included a file that can be downloaded.
[quoted text clipped - 9 lines]
> > 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.

Reply to this Message