Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    A sort of map? (Excel 2K SR1)

    I have a list of Towns in Access with grid references. I want to print then out as a sort of map. I thought the scatter chart might do this.

    Data is like:

    Town X Y
    Newbury 23 56
    Hungerford 10 55
    Oxford 24 72


    I copied the data and town names to a spreadsheet and made a scatter chart, which shows each town as a point. I am happy with this, up to a point!

    My problem is I want the name of each Town to appear by each point. Is this possible?

    Any comments gratefully received.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: A sort of map? (Excel 2K SR1)

    Try Format Data Series, and select the Data Labels tab, and check Show Label. This should show the appropriate label (town name) for each point.

    Andrew C

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A sort of map? (Excel 2K SR1)

    Andrew,

    I am not sure if you can do this the way you said. Isn't this the reason why so many MVPs have written a datalabel add-in?
    Have a look at <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=92626&page=&view= &sb=&o=&vc=1> this thread </A> where you can find the url to an MVP Page where you can download a free XYDataLabel add-in.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A sort of map? (Excel 2K SR1)

    The add-in works a treat thank you.

    Just a thought, Is it possible to link any two points together with a straight line. It won

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A sort of map? (Excel 2K SR1)

    If you select the series in the XY-chart by clicking, then click a second time (leave enough time between two successive clicks, otherwise it will be interpreted as double-click). Then goto Format >> Selected Datapoint (or something like that, I am translating this from Dutch) and customize the line between the two points that are selected.
    Another possibility is using the graphing tools, but then, changing the size of the graph will not change the used tools in the way you want.

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A sort of map? (Excel 2K SR1)

    I got the lines on as you suggested although the interface appeared to randomly select the other point and sometimes it selected more that one point. I was interested to note that I could

  7. #7
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A sort of map? (Excel 2K SR1)

    I am afraid so.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •