[mso] Re: Date format in Excel

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).=20


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
=20
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
=20
=20
Any help
=20
=20
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
*************************************************************

Other related posts: