Thread: Data Labels on Filtered Data

I am trying to put Data Labels on a Stock Chart, using a different data
source
for the chart and the labels (in adjacent columns)

I have tried various add-ins and trials (Jwalk chart tools and power pack,
XY labeler)
I have also searched high and low for an answer but all roads seem to lead
here....

The problem is that when I change the data source using the filters the data
source changes ok
but the data labels go skew-wiff.

is there a solution for this? or am I missing something obvious?

Any help would be appreciated.


Thanks

Dave

Excel 2003

Hi,

This looks like a bug in the chart object!
Once you use non built-in information in a data label the indexing
between text value and data label to display it gets confused.

Note this is NOT a bug with the labeller addins. any text whether type
directly or via linked cells will create the error.

Off hand I can not think of a cure for this, without resorting to VBA.

Cheers
Andy


ntl wrote:
> I am trying to put Data Labels on a Stock Chart, using a different data
> source
> for the chart and the labels (in adjacent columns)
>
> I have tried various add-ins and trials (Jwalk chart tools and power pack,
> XY labeler)
> I have also searched high and low for an answer but all roads seem to lead
> here....
>
> The problem is that when I change the data source using the filters the data
> source changes ok
> but the data labels go skew-wiff.
>
> is there a solution for this? or am I missing something obvious?
>
> Any help would be appreciated.
>
>
> Thanks
>
> Dave
>
> Excel 2003
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks for the answer..

I'll have to find another way of displaying the information









"Andy Pope" <andy@andypope.info> wrote in message
news:%23KMVYsziGHA.4044@TK2MSFTNGP03.phx.gbl...
> Hi,
>
> This looks like a bug in the chart object!
> Once you use non built-in information in a data label the indexing between
> text value and data label to display it gets confused.
>
> Note this is NOT a bug with the labeller addins. any text whether type
> directly or via linked cells will create the error.
>
> Off hand I can not think of a cure for this, without resorting to VBA.
>
> Cheers
> Andy
>
>
> ntl wrote:
>> I am trying to put Data Labels on a Stock Chart, using a different data
>> source
>> for the chart and the labels (in adjacent columns)
>>
>> I have tried various add-ins and trials (Jwalk chart tools and power
>> pack, XY labeler)
>> I have also searched high and low for an answer but all roads seem to
>> lead here....
>>
>> The problem is that when I change the data source using the filters the
>> data source changes ok
>> but the data labels go skew-wiff.
>>
>> is there a solution for this? or am I missing something obvious?
>>
>> Any help would be appreciated.
>>
>>
>> Thanks
>>
>> Dave
>>
>> Excel 2003
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info