Nameing scattered data in chart (dot's)

ahhh....sorry Andy!! - Ofcause! - I placed focus comletely on the
indexed-coloumn, and didnt even consider the obvious in coloumn D!!

Thanks alot ... think I got it now

Appriciate your assistance.

"Andy Pope" skrev:

The example is setup so only the righthand column displays the correct
labelling. The lefthand columns are linked directly with the original
cells and as such these do not ignore the hidden rows.

If you are still stuck you can email your file,
andy AT andypope DOT info

Cheers
Andy

On 08/03/2010 20:23, NielsChr wrote:
Yes, that am I aware of (the figures between the hiden rows), but I dont
follow this:

when you have the complete data it is clear which value are equal 1 (as I
understand it) that is AA CC EE ..etc ... and when you then want only to
illustrate values of 1 in the chart (you filter out all values equal 2 (BB DD
FF ..etc)) and then the chart (according to my wish/need) should only show AA
CC EE ..etc, but instead it shows AA BC CE etc ...
And then I cant align this to the original full data?? - make sence??

Once again thanks.
/Niels Chr

"Andy Pope" skrev:

Perhaps what is confusing is that the text used for the labels, in
column G, is within the hidden rows. So you can only see A,E and I.

Cheers
Andy


On 08/03/2010 10:16, NielsChr wrote:
Hello again Andy

I think I understand your solution of somehow making a combination that
shows the wanted sequence!

But Im not quiet understanding the logic in your example!
As the original "non-filtered" data shows that the labels linked to column B
("data") with the value 1 is "AA" "CC" "EE" "GG" and "II" nevertheless when
you filter out values equal to 2 you'll get that the labels linked to value
equal 1 is "AA" "BC" "CE" "DG" and "EI" in the chart eventhough the data
actually shows a third way (which still is not aligned with the original
data!)
Actually what you end up with ,in you link
(http://www.andypope.info/ngs/ng57.htm) , is the same diagram as you start
out with!! - Making me alittle confused

Maybe I just misunderstood the actaully purpose you are trying to illustrate
... anyway, I appriciate your help and if you understand where I go wrong am
I very interested in receiving your assistance.

thank you once again
/Niels Chr.



"Andy Pope" skrev:

Have a read of this in order to work around that problem.
http://www.andypope.info/ngs/ng57.htm

Cheers
Andy

On 07/03/2010 19:02, NielsChr wrote:
Hello Again.

Andy I hope you can help come up with a solution to the problem I
encountered from using the software you showed.

I do like it still ofcause, but it comes with an issue so fare!!
My situation is this:

I got my self around 200 rows of different car types ... when I wish my
diagram to show only one certain car type, I filter out the unwanted cars and
then leave my diagram showing only the 1 car type I like to view (e.i., VW
golf (maybe 18 cars))
Now the original row numbers to these 18 cars (label names) I link to may
vary from 3 to 78, but the chart labels still starts a 1 .. going up to 18
(or the amount of cars selected) - now I would like the labels to show
3,5,19,23 ...etc

Am I stucked with this error or am I using it incorrectly??

Hope to hear from you again.

/NielsChr


"NielsChr" skrev:

Awesome .. i love it!

I love that fact that it still is compadable to other versions than just the
English!! (I my self is using a Danish Excel version .. but still works)

Nice little application, and easy to handle.

Thank you very much Andy

"Andy Pope" skrev:

Hi,

Simplest way is to use this free add-in,
http://www.appspro.com/Utilities/ChartLabeler.htm

which will enable you to link data labels to cells.

Cheers
Andy

On 04/03/2010 21:06, NielsChr wrote:
I consider myself as a fairly competent excel user, but I seriuosly got
stucked on this on!!

Im duing a simple scattered chart with prices up along Y-axis and miles
along the X-axis ... But I would like each scattered dot to be named after
"my coloum N" which is car1, car2, car3 ...etc (Meaning .. If I have 30
Cars...where is car no. 1 in the chart and where is car no. 30) ??

The only luck I had so fare was either to show the X, Y- value or chart
name!!!
Hope someone can assist me if it is possible..

Thanks in advance
NielsChr


--

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

.


--

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

.


--

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

.


--

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

.