Thread: Graph with 0%
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
John Mansfield John Mansfield is offline
external usenet poster
 
Posts: 235
Default Graph with 0%

Yes, Andy Pope has an example on his site . . .

http://www.andypope.info/charts/piezeros.htm

--
John Mansfield
cellmatrix.net


"Question Boy" wrote:

is there a way, even with vba, to get graphs not to display 0%. I have pie
charts set on a table whose value are dynamic and in some instances they can
equeal 0. I need to stop the chart from displying 0% as a data label in
those instances only, but still display the others.

Thank you,

QB