| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In bar chart using values-NOT show the value of zero | Charts and Charting in Excel | |||
| how do i show non-numeric values graphically in a chart? | Charts and Charting in Excel | |||
| how can I show repeating values in a chart? | Charts and Charting in Excel | |||
| How can I get the zero values at the end of a chart not to show? | Charts and Charting in Excel | |||
| Chart Legend Items: hide/show | Charts and Charting in Excel | |||
Hybrid Mode
