[mso] Re: Date format in Excel - really XY graph for ANN M

Thankyou for the replies re the scatter graph using a column with
countries, the solution was to hightlight the three columns and plot the
graph and then when hovering over a point the following info would
appear, country x and y points, unfortunately there are 100 lines and
hence 100 countries, so what I am trying to do is plot the scatter graph
and when I hover over a point it shows that particular country and the
values

Any ideas

Thanks in anticipation

Ann


Ann E Fitzmaurice

Medical Statistician

Immpact

University of Aberdeen

Health Sciences Building

Foresterhill

Aberdeen, AB25 2ZD

Scotland, United Kingdom

=20

Tel: +44 (0)1224 553876

Fax: +44 (0)1224 555704

Email: a.e.fitzmaurice@xxxxxxxxxx

url: http//www.immpact-international.org/


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Tillotson, Robert N (US SSA)
Sent: 30 October 2007 12:57
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Date format in Excel - really XY graph for ANN M



Ann
I am assuming your data in in three columns next to each other.  This
works for Excel 2003.
When you create the graph, select all the data in the three columns
before you click the chart wizard. Then click the chart wizard button
(or however you start the wizard in your version). Select scatter graph
and accept all the defaults for the chart.  Don't choose to label the
points.  Then when you hover over a point it will list the country as
the point name and the x and y as values for it, like: series 1  point
"Albania" (23, 34).=3D3D20


Robert Tillotson
BAE-IT
Groton Field Office
860-441-2207

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of ANN FITZMAURICE
Sent: Tuesday, October 30, 2007 3:51 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Date format in Excel

hi
=3D3D20
Am trying to draw a scatter graph in excel, have 3 column , name of
country , x value and y value, I can draw the x y graph using scatter
graph , what I want to do is when I hover over a point I want to be able
to read the point values in addition to the name of the country, I can
at present read the x y values but not the name of the country. I do not
want to have the values reproduced on the graph as there are too many
points for the values to be read =3D3D20 =3D3D20 Any help =3D3D20 =
=3D3D20 ann
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top.  This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister
group.  This group will not allow for posting of emails, but will allow
you to join and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
FILE SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your
email messages, read these instructions that explain why and how to fix
it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top.  This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister
group.  This group will not allow for posting of emails, but will allow
you to join and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
FILE SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your
email messages, read these instructions that explain why and how to fix
it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top.  This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister
group.  This group will not allow for posting of emails, but will allow
you to join and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
FILE SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your
email messages, read these instructions that explain why and how to fix
it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: