If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Nameing scattered data in chart (dot's)
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 |
#2
|
|||
|
|||
Nameing scattered data in chart (dot's)
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 |
#3
|
|||
|
|||
Nameing scattered data in chart (dot's)
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 . |
#4
|
|||
|
|||
Nameing scattered data in chart (dot's)
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 . |
#5
|
|||
|
|||
Nameing scattered data in chart (dot's)
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 |
#6
|
|||
|
|||
Nameing scattered data in chart (dot's)
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 . |
#7
|
|||
|
|||
Nameing scattered data in chart (dot's)
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 |
#8
|
|||
|
|||
Nameing scattered data in chart (dot's)
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 . |
#9
|
|||
|
|||
Nameing scattered data in chart (dot's)
Furthermore Andy ..just wanna say I like your formulas, but I cant seem to
adjust it to my need which is written in prior statement. "NielsChr" skrev: 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 . |
#10
|
|||
|
|||
Nameing scattered data in chart (dot's)
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 |
|
Thread Tools | |
Display Modes | |
|
|