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

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

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

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

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

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

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.

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.

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.

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.