Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I really need to figure this out.... please help Is there a way to add custom datalabels to a chart? Like may be like adding a certain values of the range as datalable. To explain this better, if I have a set of rows where the alternate row starts as datalabel like shown below. type 1 type 2 type 3 type 4 type 5 value 6.11864 4.16794 6.36036 6.38182 5.64151 lable 4.1N 4.2 3.2DN 2.1SR 4.5 Usually type 1 and so on will show up as datalabel. But my question is can I make the change to the databale values to be the values in the row that corresponds to lable in the above table. Condition is as long as the value has any Alpha charecter apply that value to the datalabel other wise if the value is just numeric or blank then do not show or apply the datalable. Hope I am clear ...... Please some one help me this is very important. Yesh |