Alternative to XY chart labeller (www.appspro.com/Utilities/ChartL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 29 Sep 2007 11:41 GMT

Hi Folks
This add in is great, until I add a filter to the underlying XY & label data.

I need to apply a filter as I have several hundred XY co-ordinates & labels,
and regularly need to filter down to different subsets of the data.

When a filter is applied, the labels linked to the associated XY become
incorrect.

Does anyone know a solution to this?

Thanks

Steve

Reply to this Message

Andy Pope - 29 Sep 2007 13:45 GMT

Hi,

This is not a problem with the addin but more how charts deal with
filtered data and the linked labels.
The points used always goes 1 to n, where n is the number of data
points. So when filtering the points go 1 to n-filtered.
All of the charts automatic items, category labels and data values, are
updated but the links between data labels and cells remains static.

I have posted a page that uses formula to get around the static nature
of the linking.
http://www.andypope.info/ngs/ng57.htm

Cheers
Andy

> Hi Folks
> This add in is great, until I add a filter to the underlying XY & label data.
[quoted text clipped - 10 lines]
>
> Steve

Reply to this Message

Steve - 30 Sep 2007 09:49 GMT

Thanks Andy
I would never have come up with that solution in a million years!

Cheers

Steve

> Hi,
>
[quoted text clipped - 26 lines]
> >
> > Steve

Reply to this Message