Thread: Please help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Yeshwin[_2_] Yeshwin[_2_] is offline
external usenet poster
 
Posts: 4
Default Please help

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