[mso] Re: Help with Sumproduct for ann's question not the original question

Ann,

When you create teh graph, select all three columns before you click the
chart wizard.  Then when you hover over the 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
Sent: Monday, October 29, 2007 3:08 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Help with Sumproduct=20

Hi

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

Any help

ann

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Sabil Shah
Sent: 22 June 2007 10:36
To: Linda F Johson
Subject: [mso] Help with Sumproduct=20

Dear Friends,
  =20
  I have data Regionwise (NORTH,EAST,WEST & SOUTH) with different over
due days, & collected values.  Overdue days are 1-2000, I wish to get
values in break of <90,  >91>180 & >180days, Regionwise.
  =20
  I use sumproudct but no result only 0 comes.
  =20
  Please help, what error can be there, or more suitable formula.
  =20
  Regds,
  =20
  =20
      =20
---------------------------------
 The DELETE button on Yahoo! Mail is unhappy. Know why?

*************************************************************
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: