Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.charting
|
|||
|
|||
data labels on charts
Hi,
how can i change #N/D! label into "n/a" or "" with some VBA code. i have column chart with series which data end before end of period. i.e values a =1.3 =1.4 =1.3 =1.2 =NA() =NA() labels a 1.3 (non-zero column) 1.4 (non-zero column) 1.3 (non-zero column) 1.2 (non-zero column) #N/D! (zero value column) #N/D! (zero value column) how can i change ONLY labels with #N/D! into "n/a" or "" is there possibility of change without loosing functionality because sometimes series are fully with data. and how i can change labelling only for particulars charts? regards |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.charting
|
|||
|
|||
data labels on charts
If the label says "#N/A" in the chart, and the column has an apparent value
of zero, then any text value will do the same. Assuming the source data is filled with formulas, change the formulas to something like: =IF(ISNA(formula),"#N/D!",formula) - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - Training in Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "God Itself" wrote in message ... Hi, how can i change #N/D! label into "n/a" or "" with some VBA code. i have column chart with series which data end before end of period. i.e values a =1.3 =1.4 =1.3 =1.2 =NA() =NA() labels a 1.3 (non-zero column) 1.4 (non-zero column) 1.3 (non-zero column) 1.2 (non-zero column) #N/D! (zero value column) #N/D! (zero value column) how can i change ONLY labels with #N/D! into "n/a" or "" is there possibility of change without loosing functionality because sometimes series are fully with data. and how i can change labelling only for particulars charts? regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data labels for charts | Charts and Charting in Excel | |||
Data Labels for Charts | Excel Discussion (Misc queries) | |||
data labels in charts | Charts and Charting in Excel | |||
Data labels on charts | Excel Discussion (Misc queries) | |||
Data Labels on charts | Charts and Charting in Excel |