X Y Scatter With Point name on each point ?

I need to create a excel chart with three columns which are x coordinate, y 
coordinate and country name. I need a scatter chart, with point name labeled 
againt each point. e.g. In the below example, I need country name to identify 
each point in the chart. Pl. help !

x    y  Cname
1   5   US
2   2   Canada
5   7   Brazil
6   2   UK 

0
Raj (124)
7/27/2007 3:30:00 PM
excel.charting 18370 articles. 0 followers. Follow

3 Replies
626 Views

Similar Articles

[PageSpeed] 44

Hi,

Create a xy-scatter on the first to columns of data and then use Rob Bovey's 
free addin to link data labels to cells.
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

-- 

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Raj" <Raj@discussions.microsoft.com> wrote in message 
news:918AE909-D110-4B78-8A8E-04D4D55D749F@microsoft.com...
>I need to create a excel chart with three columns which are x coordinate, y
> coordinate and country name. I need a scatter chart, with point name 
> labeled
> againt each point. e.g. In the below example, I need country name to 
> identify
> each point in the chart. Pl. help !
>
> x    y  Cname
> 1   5   US
> 2   2   Canada
> 5   7   Brazil
> 6   2   UK
> 

0
andy9699 (3616)
7/27/2007 3:38:28 PM
Thanks Much Andy, I found one of your ealier answer also, tried it out and 
worked !!

Do you know if this is something microsoft is planning add as a inbuilt 
feature  ?

"Andy Pope" wrote:

> Hi,
> 
> Create a xy-scatter on the first to columns of data and then use Rob Bovey's 
> free addin to link data labels to cells.
> http://www.appspro.com/Utilities/ChartLabeler.htm
> 
> Cheers
> Andy
> 
> -- 
> 
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "Raj" <Raj@discussions.microsoft.com> wrote in message 
> news:918AE909-D110-4B78-8A8E-04D4D55D749F@microsoft.com...
> >I need to create a excel chart with three columns which are x coordinate, y
> > coordinate and country name. I need a scatter chart, with point name 
> > labeled
> > againt each point. e.g. In the below example, I need country name to 
> > identify
> > each point in the chart. Pl. help !
> >
> > x    y  Cname
> > 1   5   US
> > 2   2   Canada
> > 5   7   Brazil
> > 6   2   UK
> > 
> 
> 
0
Raj (124)
7/27/2007 4:26:01 PM
Well, people have requested it for a long time, and it still hasn't made it 
into Excel 2007. You could hope it makes it into the next version, in around 
2010.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Raj" <Raj@discussions.microsoft.com> wrote in message 
news:4BBA581B-F06C-4AAF-BF62-C46F5442D76E@microsoft.com...
> Thanks Much Andy, I found one of your ealier answer also, tried it out and
> worked !!
>
> Do you know if this is something microsoft is planning add as a inbuilt
> feature  ?
>
> "Andy Pope" wrote:
>
>> Hi,
>>
>> Create a xy-scatter on the first to columns of data and then use Rob 
>> Bovey's
>> free addin to link data labels to cells.
>> http://www.appspro.com/Utilities/ChartLabeler.htm
>>
>> Cheers
>> Andy
>>
>> -- 
>>
>> Andy Pope, Microsoft MVP - Excel
>> http://www.andypope.info
>> "Raj" <Raj@discussions.microsoft.com> wrote in message
>> news:918AE909-D110-4B78-8A8E-04D4D55D749F@microsoft.com...
>> >I need to create a excel chart with three columns which are x 
>> >coordinate, y
>> > coordinate and country name. I need a scatter chart, with point name
>> > labeled
>> > againt each point. e.g. In the below example, I need country name to
>> > identify
>> > each point in the chart. Pl. help !
>> >
>> > x    y  Cname
>> > 1   5   US
>> > 2   2   Canada
>> > 5   7   Brazil
>> > 6   2   UK
>> >
>>
>> 


0
jonxlmvpNO (4558)
7/27/2007 7:47:15 PM
Reply:

Similar Artilces:

company name change
Hello Our company has recently changes names. We already have two email domains currently in use, one set as primary for everything and another which was used in the past. We have one defined SMTP address, which is primary for all users. We also have another which was used int he past, but is not listed as a SMTP address in EXCH system mgr, recipients policies. Of course, I have a new domain to add as our primary smtp address and will need to make the current smtp address secondary for users. In EXCH system mgr, I do see CCMAIL and MS properties which appear to be our old email domain...

Filtering on originators NAME
Outlook 2003: Is it possible to create a rule which operates on the originators stated name, as in: From: _this_bit_ <my@email.address> ? I don't know anyone whose *name* contains Xanax, Cialis or Valium, but they sure are sending me a heck of a lot of mail! (Which I'd love to filter out) -- Steve Swift http://www.ringers.org.uk (Personal Webpage) http://hedgehog.farn.uk.ibm.com (IBM Internal - restricted) You can create a rule that scans he message header for these names. Isn't your Junk E-mail Filter catching these already? They are filtered out for me alrea...

Named Ranges
I have a worksheet with a large number of named ranges. Is there any way I can print a list of these together with their references. Thank you & Regards Ian Bull Ian, Insert a new worksheet. Copy, paste and Run this macro (with the new worksheet active). Sub ListNamedRanges() Dim NamedRange As Name Dim x As Integer x = 1 For Each NamedRange In Names Cells(x, 1) = NamedRange.Name Cells(x, 2) = NamedRange x = x + 1 Next NamedRange End Sub John Ian Bull wrote: > I have a worksheet with a large number of named ranges. > > Is there...

Empty cells at start of x axis
I have two charts that are the same size and I want to print them separately and compare data by physically laying one above the other on a table. The x axis on one has dates, i.e. Oct. 1 Oct. 2 Oct. 3 etc The x axis on the other has numbers starting at #1, 1 2 3 etc How do I get two empty cells at the start of "number" chart so that the number 1 starts in the third cell from the left? When the two charts are laying one above the other, their x axis would look like this: Oct 1 Oct 2 Oct 3 Oct 4 ...

Vary colors in area chart by x-axis value
I have an area chart that displays electricity usage (y-axis) for each hour of one day (x-axis). I want hours 1-7 to be blue, 8-12 green, etc. -- Deirdre M. Hi Deirdre, There is a 'Conditional Chart Formatting' sample workbook at http://edferrero.m6.net/charting.aspx Ed Ferrero http://edferrero.m6.net/ >I have an area chart that displays electricity usage (y-axis) for each hour > of one day (x-axis). I want hours 1-7 to be blue, 8-12 green, etc. > > -- > Deirdre M. ...

HTML_Control Range name
I have a problem with one of my macros where I am copy an entire worksheet (not by range) to another workbook. However, every other worksheet it seems comes across with an message indicating that that range name HTML_Control already exists. I had run a piece of code in my worksheet to outline all range names and it appears to be some kind of range name....and to my surprise there are a whole bunch of other names as well. Can someone tell me if there is any specific purpose for it? Hi, Do you have controls on the worksheet? If so try renaimng them to something other than commandbutton1...

Horizontal Time (X-axis)
Hello, I am attemping to graph a horizontal 24 hour time period in Excel. At the left side would be 08:00 and at the right side would be 07:59 On that bar I am attempting to plot the start and ending times of 14 batch jobs that run in order to track them over time and adjust the schedules to be more efficient. I have run through all the graphs that are built in and the closest I have come is a diagonal, 45 degree, line of time. My column A is the name of the jobs My column B is the start time of the jobs My column C is the 24 hour clock (08:00; 09:00, 10:00, 11:00, 12:00, 13:00...2...

Can anyione point out why?
Hi all, In my test environment, I import the certificate from production to my exchange 2003 frontend server on my test environemnt and configure it to require SSL. I got "the page can not be dispalyed" If I access the OWA through https://frontend server/exchange. If I removed the certificate, the OWA through http://frontend server/exchange is fine. Can anyone point me to the right direction? THANKS! What kind of certificate do you have. It sounds like it may be a server certificate, in which case it will only be good on the server with the correct name on it. -- -- --...

Report Name Customer
Hi We have created a custom report in Visual Studio which shows all the service activities per customer in CRM. I now would like to display the customer name which was used in the filter as the heading of the report. If no customer was selected the heading should be blank. Do I need to use CRM_FilterText to achieve this? I have attempted to insert a parameter without success. I would really appreciate some guidance in how to achieve this. Many Thanks Mark no you can easily achieve this with a table group heading "Mark Braithwaite" <MarkBraithwaite@discussions.microsoft....

Connecting two series in a scatter chart
Hello - I have a user who created a scatter chart. The chart contains two series: "HO" and "PD" - the HO data point has a related PD data point. She would like to have Excel add a connector line from the HO data point to the corresponding PD data point. Is this possible? I apologize that I am not familiar with this type of chart, or the lingo, so please let me know what other information you would need to answer this question. We are using Excel 2007. Thanks very much! Hi, Double-click one of the series, in the format series dialog box choose the Options tab, and ch...

XPS Default File Name
Hi there: I am printing to a .xps file. However, each file I save from .xls, prompts for a file name with the .xps set as the default. Does anyone know how to set the current workbook name of a .xls file as the default name for the .xps file? Much Appreciated, David I guess you should save via a macro: Sub SaveActiveWBookAsXPS() Dim WBName As String Dim DotPos As Integer WBName = ActiveWorkbook.Name DotPos = InStrRev(WBName, ".") If DotPos > 0 Then WBName = Left(WBName, DotPos - 1) ActiveSheet.ExportAsFixedFormat Type:=xlTypeXPS, Filename:="C:\...

Week numbers on X-axis
Hi, I have a chart that should display the project status over a number of weeks. It all works fine when you have a continous array of weeks (e.g w430 - w450). But when the projects runs over the NewYear (e.g w430 - w506) I have problems with my x-axis. The week numbers (430 - 506) appears to the left on the x-axis and to the right I only get marks on the axis but no numbers. I would like to have the weeks spread evenly on the x- axis, starting with 430 and ending with 506 (an across the New Year; ... 451, 452, 452, 501, 502 etc). I save the wanted x-axis in an array (1 to LastWeek) and...

OL2003: Names Do Not Appear in the "Search Results" Box When You Search for Names That Have Double Byte Character Set Characters in a LDAP Address Book?
> how can i do? > microsoft.com only say the ol2002 but not say ol2003! > OL2003: Names Do Not Appear in the "Search Results" Box When You Search > for Names That Have Double Byte Character Set Characters in a LDAP Address > Book > SYMPTOMS > In Microsoft Outlook, you can search for names in a Lightweight Directory > Access Protocol (LDAP) address book that you want to insert in the To box, > the Cc box, or the Bcc box of an e-mail message. However, if the name that > you are searching for contains Double Byte Character Set (DBCS) characters > (...

Modifying the Assembly transaction entry window-X in corner
I would like to modify the window that pops open after you change anything on the Assembly Transaction entry window (Transaction>Inventory>Assembly Entry) This window is labelled: Microsoft Dynamics GP and the question is: Do you want to sasve changes or delete document number xxxxx (I would like to remove the delete button) How do I find this window in modifier? thanks -- Doug That is a dialog box, and it does not exist as a "window" that can be modified. To accomplish what you want you would need to modify the behavior of the Assembly Trx window to prevent ...

Can you chart an equation (y=mx+b)?
I am trying to set up a graph in MS Excel where you can enter in the values for X and B and it will graph the line, like a graphing caluclator would. Is that possible? Excel graphs points, not equations. For a straight line, you would only need to calculate the first and last points on the line and plot them as an "XY (Scatter)" chart with points connected by a line. Alternately, Tushar Mehta has written an add-in for plotting functions http://www.tushar-mehta.com/excel/software/plot_manager/index.html Jerry Adam wrote: > I am trying to set up a graph in MS Excel wh...

Short cut key Ctrl Y (repeat last motion) in Publisher won't work
The help menu tells me that I can use the Ctrl 7 to repeat the last action I made. However I have not been able to do so. Please help. I can use all other shortcut keys. This is making me crazy -- I can do my work in half the time with the Ctrl 7. It tells me I can also use F4 but this doesn't work either-a moot point since I use the other that speeds my work considerably. HELP! Where did you find those commands? -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com http://officebeta.iponet.net/en-us/publisher/FX100649111033.as...

Convert Power Point presentation
I have old presentation that I need to convert from "read me only file" so I can edit or redo it. Can you email me. (Vista Home Addition). Thanks Jamesjhdr22@yahoo.com Jim wrote: > I have old presentation that I need to convert from "read me only > file" so I can edit or redo it. Can you email me. (Vista Home > Addition). > Thanks > Jamesjhdr22@yahoo.com =================================== Did you try opening the file in MS PowerPoint? -- John Inzer MS-MVP Digital Media Experience Notice This is not tech support I am a volunteer ...

Microsoft Outlook 2000 error The Name Coud Not Be Resolved
Hi to All, I have a windows 98 SE client with Outlook 2000 professional installed. I cannot add exchange mailbox because there is an error when I tried to connecto to exchange 2000 Enterprise Edition upgrade from exchange 5.5. The name could not be resolved when I tried to get the users mailbox. However in Windows 2000 DC I installed the Outlook 2000 and it is working fine. Please I need a help. Thanks in advance!! Emslan Follow http://support.microsoft.com/kb/839880/en-us Also check DNS settings on Win 98 machine. emslan wrote: > Hi to All, > I have a windows 98 SE client with ...

User Name
Is there a formula to capture the current user's name (%username%) in a cell? I do not want to use any code that will ask the users to enable macro when they open the document. Thanks! xjvs Use a UDF Function UserName() UserName = Environ("UserName") End Function and use ina cell like this =UserName() -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "JVS" <sirera1@verizon.net> wrote in message news:ELi8h.2161$yV.987@trnddc07... > Is there a formula to capture the current user's name (%username%) in a &...

Desktop names have been changed
Don't know how this happened - but most of my Desktop file and folder names have been changed. Following is an example: e9193x999233 (12) This is what it was changed to. When Vista SP2 boots, just for a moment the correct name appears. But then, the names change to something like what I showed above. I tried System Restore and ERUNT - no luck. Can anyone tell me how to retrieve the file and folder names? On Sun, 06 Jun 2010 20:45:22 -0400, PeoplesChoice@Chicago.net wrote: > Don't know how this happened - but most of my Desktop file and folder > names...

Primary Axis(X) Formating Issue
I'm using a custom type chart (Lines on 2 Axes) and I'm using two different ranges for the Category (X) axis labels and the Second category (X) axis labels in order to display some additional information on the chart. When I say two different ranges I mean the rows are the same, but the columns are different. The problem I'm having is I want to use a custom format (dd-MMM-yy) to display the dates, but when I do so the dates have format MMM-yy-dd. The only way I can get the dates to display accurately is to use the Date format with the * (either *03/14/01 or *March 14, 20...

Data Series Name
I am trying to add wording in an Excel data series name, but also keep the value linked to a cell in the spreadsheet. For example, the linked cell will sum values from other cells. So, the data series name will equal that sum, but in front of the summed value I would like to add the words "Total Sales". Can this be done? You have to construct the label in the worksheet cell, then link to it in the series formula (or source data dialog). For example, if the series name is in cell B1 and the value you want is in C1, enter this formula in B1: ="Total Sales "&C1...

Edit Contact Command doesn't remmber the Name
1) Right click Sent items folder in Storage folder. 2) Click Find. Put a name in the To: field. Click Find Now. 3) Click on an email message found. 4) Right click on a name in the To: field, a name that includes the First Name and Last Name. 5) Click Edit Contact. If the person isn't already in your Contacts the First Name and last name fields are blank in spite of the fact that their name was clearly visible in step 4. 6) Why does Windows Live mail do this and is there a way around this other than typing in their name? Of course the whole point here is to add the...

Change name of tab sheet
The 'help' menu tells me to double click on the tab sheet and override the name. When I do this, nothing happens! delaze@chartermi.net Hello, Double-clicking should highlight the sheet name, allowing you to change it just be typing. If you can't get it to work, try right-clicking on the sheet name, and selecting rename from the menu. If that doesn't work, the worksheet is probably protected. Choose Tools, Protect, from the menu bar, and see if there is a menu option "Unprotect Sheet". If so, the sheet is protected. If is says "Protect Sheet", then...

deleting worksheets from names in a range
Is there anyway to delete worksheets via code where one worksheet contains a range with the names of the tabs on the worksheets I want to delete? i.e., Sheet 1 has a range that has the values, A, B, C. These are the names on tabs for 3 worksheets. I want to have code that says "delete worksheets with the tabs named A, B, C. Let me know if you need more info. TIA! With Worksheets("Sheet1") Application.DisplayAlaerts = False For i = 1 To Cells(Rows.Count,"A").End(xlUp).Row On Error Resume Next Worksheets(Cells(i,"A...