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