| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph with 0%
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Graph with 0%
I use Excel 2003, so I hope this still applies. After you make your chart,
double click on the offending 0% label. The cursor should change to text. Simply delete the text of the label. "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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Graph with 0%
Bonsour® "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. Use personal format for data labels : 0%,,, or general,,, by VBA Selection.NumberFormat = "0%,,," or Selection.NumberFormat = "general,,," -- -- @+ ;o))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
| How do I plot multiple series on one graph? - test-graph.xls (0/1) | Charts and Charting in Excel | |||
| How do I plot multiple series on one graph? - test-graph.xls (1/1) | Charts and Charting in Excel | |||
| Creating a graph similar to a stacked column graph | Charts and Charting in Excel | |||
| Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
Linear Mode
