| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Should I use a scatter graph?
I would like to chart some various housing compounds based on rental
rate (y) vs their size, in this case bedrooms (x). I can get the look and results that I want, but I can't get the label of the compound (A,B or C) next to the data point. I have never used scatter graphs before, so I'm not sure if this is the correct path. Should I be using a scatter graph? Sample Compound Bedrooms Lease A 4 16,000 B 4 18,000 C 5 19,000 Thanks in advance. kdaniel7979 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should I use a scatter graph?
Please don't multipost. Crosspost if you must, but in general if you ask
the question in .excel.charting (which you have done), that will be your best bet for this type of question. http://www.cs.tut.fi/~jkorpela/usenet/xpost.html -- David Biddulph wrote in message ps.com... I would like to chart some various housing compounds based on rental rate (y) vs their size, in this case bedrooms (x). I can get the look and results that I want, but I can't get the label of the compound (A,B or C) next to the data point. I have never used scatter graphs before, so I'm not sure if this is the correct path. Should I be using a scatter graph? Sample Compound Bedrooms Lease A 4 16,000 B 4 18,000 C 5 19,000 Thanks in advance. kdaniel7979 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should I use a scatter graph?
In fairness, Daniel's post in the charting group appeared after this one.
Presumably he discovered that group after making this post. I saw the post first in the charting group, because that's the one I read first, and I've answered it there. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Please don't multipost. Crosspost if you must, but in general if you ask the question in .excel.charting (which you have done), that will be your best bet for this type of question. http://www.cs.tut.fi/~jkorpela/usenet/xpost.html -- David Biddulph wrote in message ps.com... I would like to chart some various housing compounds based on rental rate (y) vs their size, in this case bedrooms (x). I can get the look and results that I want, but I can't get the label of the compound (A,B or C) next to the data point. I have never used scatter graphs before, so I'm not sure if this is the correct path. Should I be using a scatter graph? Sample Compound Bedrooms Lease A 4 16,000 B 4 18,000 C 5 19,000 Thanks in advance. kdaniel7979 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should I use a scatter graph?
But if kdaniel were really nice <bg, he would have come back to this post and
said: "Hey, I just found the .charting newsgroup and reposted there. Please don't respond to this post." (I don't see these kinds of warnings very often--but they do happen (which is nice!).) Jon Peltier wrote: In fairness, Daniel's post in the charting group appeared after this one. Presumably he discovered that group after making this post. I saw the post first in the charting group, because that's the one I read first, and I've answered it there. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Please don't multipost. Crosspost if you must, but in general if you ask the question in .excel.charting (which you have done), that will be your best bet for this type of question. http://www.cs.tut.fi/~jkorpela/usenet/xpost.html -- David Biddulph wrote in message ps.com... I would like to chart some various housing compounds based on rental rate (y) vs their size, in this case bedrooms (x). I can get the look and results that I want, but I can't get the label of the compound (A,B or C) next to the data point. I have never used scatter graphs before, so I'm not sure if this is the correct path. Should I be using a scatter graph? Sample Compound Bedrooms Lease A 4 16,000 B 4 18,000 C 5 19,000 Thanks in advance. kdaniel7979 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should I use a scatter graph?
Yeah, you're right. Maybe we should go beat him up!
Or maybe not. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dave Peterson" wrote in message ... But if kdaniel were really nice <bg, he would have come back to this post and said: "Hey, I just found the .charting newsgroup and reposted there. Please don't respond to this post." (I don't see these kinds of warnings very often--but they do happen (which is nice!).) Jon Peltier wrote: In fairness, Daniel's post in the charting group appeared after this one. Presumably he discovered that group after making this post. I saw the post first in the charting group, because that's the one I read first, and I've answered it there. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Please don't multipost. Crosspost if you must, but in general if you ask the question in .excel.charting (which you have done), that will be your best bet for this type of question. http://www.cs.tut.fi/~jkorpela/usenet/xpost.html -- David Biddulph wrote in message ps.com... I would like to chart some various housing compounds based on rental rate (y) vs their size, in this case bedrooms (x). I can get the look and results that I want, but I can't get the label of the compound (A,B or C) next to the data point. I have never used scatter graphs before, so I'm not sure if this is the correct path. Should I be using a scatter graph? Sample Compound Bedrooms Lease A 4 16,000 B 4 18,000 C 5 19,000 Thanks in advance. kdaniel7979 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should I use a scatter graph?
My avatar will be right behind your avatar!
Jon Peltier wrote: Yeah, you're right. Maybe we should go beat him up! Or maybe not. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dave Peterson" wrote in message ... But if kdaniel were really nice <bg, he would have come back to this post and said: "Hey, I just found the .charting newsgroup and reposted there. Please don't respond to this post." (I don't see these kinds of warnings very often--but they do happen (which is nice!).) Jon Peltier wrote: In fairness, Daniel's post in the charting group appeared after this one. Presumably he discovered that group after making this post. I saw the post first in the charting group, because that's the one I read first, and I've answered it there. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Please don't multipost. Crosspost if you must, but in general if you ask the question in .excel.charting (which you have done), that will be your best bet for this type of question. http://www.cs.tut.fi/~jkorpela/usenet/xpost.html -- David Biddulph wrote in message ps.com... I would like to chart some various housing compounds based on rental rate (y) vs their size, in this case bedrooms (x). I can get the look and results that I want, but I can't get the label of the compound (A,B or C) next to the data point. I have never used scatter graphs before, so I'm not sure if this is the correct path. Should I be using a scatter graph? Sample Compound Bedrooms Lease A 4 16,000 B 4 18,000 C 5 19,000 Thanks in advance. kdaniel7979 -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should I use a scatter graph?
On Aug 31, 9:46 pm, Dave Peterson wrote:
My avatar will be right behind your avatar! Jon Peltier wrote: Yeah, you're right. Maybe we should go beat him up! Or maybe not. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Dave Peterson" wrote in message ... But if kdaniel were really nice <bg, he would have come back to this post and said: "Hey, I just found the .charting newsgroup and reposted there. Please don't respond to this post." (I don't see these kinds of warnings very often--but they do happen (which is nice!).) Jon Peltier wrote: In fairness, Daniel's post in the charting group appeared after this one. Presumably he discovered that group after making this post. I saw the post first in the charting group, because that's the one I read first, and I've answered it there. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Please don't multipost. Crosspost if you must, but in general if you ask the question in .excel.charting (which you have done), that will be your best bet for this type of question. http://www.cs.tut.fi/~jkorpela/usenet/xpost.html -- David Biddulph wrote in message ups.com... I would like to chart some various housing compounds based on rental rate (y) vs their size, in this case bedrooms (x). I can get the look and results that I want, but I can't get the label of the compound (A,B or C) next to the data point. I have never used scatter graphs before, so I'm not sure if this is the correct path. Should I be using a scatter graph? Sample Compound Bedrooms Lease A 4 16,000 B 4 18,000 C 5 19,000 Thanks in advance. kdaniel7979 -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - Wow look at all the reponses about cross posting. Sorry, absolutely right I didn't know about the charting newsgroup until after. By the way....anyone want to offer advice on how to solve this? ;-) I did ust that add in program that someone had mentioned. Works great, but I can only use that at home. I can't add untested software to my office comp. Big international company you know. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should I use a scatter graph?
I don't think you're going to be able to get better advice than you got in
the charting group, where Jon Peltier is the acknowledged expert. I guess that if the company won't allow you to use the add-ins recommended, they'll be happier to pay for you to write some add-ins of your own to do the same job (and for you to test them to the company's satisfaction), or to pay you to add the labels manually to each point? Your situation is understood, & we sympathise. -- David Biddulph wrote in message ups.com... Wow look at all the reponses about cross posting. Sorry, absolutely right I didn't know about the charting newsgroup until after. By the way....anyone want to offer advice on how to solve this? ;-) I did ust that add in program that someone had mentioned. Works great, but I can only use that at home. I can't add untested software to my office comp. Big international company you know. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should I use a scatter graph?
You could find where the add-in is installed on your home computer, copy it
to a flash drive (if you're allowed to use the USB ports on your work computer, that is), copy it to a directory on your work computer which you have access to, and install it using Tools menu Add-Ins Browse. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ups.com... On Aug 31, 9:46 pm, Dave Peterson wrote: My avatar will be right behind your avatar! Jon Peltier wrote: Yeah, you're right. Maybe we should go beat him up! Or maybe not. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Dave Peterson" wrote in message ... But if kdaniel were really nice <bg, he would have come back to this post and said: "Hey, I just found the .charting newsgroup and reposted there. Please don't respond to this post." (I don't see these kinds of warnings very often--but they do happen (which is nice!).) Jon Peltier wrote: In fairness, Daniel's post in the charting group appeared after this one. Presumably he discovered that group after making this post. I saw the post first in the charting group, because that's the one I read first, and I've answered it there. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Please don't multipost. Crosspost if you must, but in general if you ask the question in .excel.charting (which you have done), that will be your best bet for this type of question. http://www.cs.tut.fi/~jkorpela/usenet/xpost.html -- David Biddulph wrote in message ups.com... I would like to chart some various housing compounds based on rental rate (y) vs their size, in this case bedrooms (x). I can get the look and results that I want, but I can't get the label of the compound (A,B or C) next to the data point. I have never used scatter graphs before, so I'm not sure if this is the correct path. Should I be using a scatter graph? Sample Compound Bedrooms Lease A 4 16,000 B 4 18,000 C 5 19,000 Thanks in advance. kdaniel7979 -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - Wow look at all the reponses about cross posting. Sorry, absolutely right I didn't know about the charting newsgroup until after. By the way....anyone want to offer advice on how to solve this? ;-) I did ust that add in program that someone had mentioned. Works great, but I can only use that at home. I can't add untested software to my office comp. Big international company you know. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should I use a scatter graph?
On Sep 5, 3:35 pm, "Jon Peltier"
wrote: You could find where the add-in is installed on your home computer, copy it to a flash drive (if you're allowed to use the USB ports on your work computer, that is), copy it to a directory on your work computer which you have access to, and install it using Tools menu Add-Ins Browse. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ups.com... On Aug 31, 9:46 pm, Dave Peterson wrote: My avatar will be right behind your avatar! Jon Peltier wrote: Yeah, you're right. Maybe we should go beat him up! Or maybe not. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Dave Peterson" wrote in message ... But if kdaniel were really nice <bg, he would have come back to this post and said: "Hey, I just found the .charting newsgroup and reposted there. Please don't respond to this post." (I don't see these kinds of warnings very often--but they do happen (which is nice!).) Jon Peltier wrote: In fairness, Daniel's post in the charting group appeared after this one. Presumably he discovered that group after making this post. I saw the post first in the charting group, because that's the one I read first, and I've answered it there. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Please don't multipost. Crosspost if you must, but in general if you ask the question in .excel.charting (which you have done), that will be your best bet for this type of question. http://www.cs.tut.fi/~jkorpela/usenet/xpost.html -- David Biddulph wrote in message ups.com... I would like to chart some various housing compounds based on rental rate (y) vs their size, in this case bedrooms (x). I can get the look and results that I want, but I can't get the label of the compound (A,B or C) next to the data point. I have never used scatter graphs before, so I'm not sure if this is the correct path. Should I be using a scatter graph? Sample Compound Bedrooms Lease A 4 16,000 B 4 18,000 C 5 19,000 Thanks in advance. kdaniel7979 -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - Wow look at all the reponses about cross posting. Sorry, absolutely right I didn't know about the charting newsgroup until after. By the way....anyone want to offer advice on how to solve this? ;-) I did ust that add in program that someone had mentioned. Works great, but I can only use that at home. I can't add untested software to my office comp. Big international company you know. Thanks Jon. I'll try that next week. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shading on a scatter graph | Charts and Charting in Excel | |||
| problem with scatter graph | Charts and Charting in Excel | |||
| scatter graph | Charts and Charting in Excel | |||
| Text box in scatter graph | Charts and Charting in Excel | |||
| XY scatter graph | Charts and Charting in Excel | |||
Linear Mode
