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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data labels on charts | Charts and Charting in Excel | |||
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 | |||
cut data labels in bar charts | Excel Programming |