LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"