| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
