ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Scatter Chart (https://www.excelbanter.com/charts-charting-excel/143354-scatter-chart.html)

Phil Stanton

Scatter Chart
 
I am trying to create a scatter chart to show points of interest on a map.

I have a column of x co-ordinates, and corresponding y co-ordinates and the
place name (Actually the whole lot comes out of an Access database)

Is it possible to show the labels next to a marker at the appropriate x,y
position. I am assuming somehow it can be done on a scatter chart.

Many thanks for any advice

Phil



Andy Pope

Scatter Chart
 
Hi,

The simplest way is to use Rob Bovey's free addin
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

Phil Stanton wrote:
I am trying to create a scatter chart to show points of interest on a map.

I have a column of x co-ordinates, and corresponding y co-ordinates and the
place name (Actually the whole lot comes out of an Access database)

Is it possible to show the labels next to a marker at the appropriate x,y
position. I am assuming somehow it can be done on a scatter chart.

Many thanks for any advice

Phil



Phil Stanton

Scatter Chart
 
Thanks, Andy

Worked a treat

Cheers
Phil


"Andy Pope" wrote in message
...
Hi,

The simplest way is to use Rob Bovey's free addin
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

Phil Stanton wrote:
I am trying to create a scatter chart to show points of interest on a
map.

I have a column of x co-ordinates, and corresponding y co-ordinates and
the place name (Actually the whole lot comes out of an Access database)

Is it possible to show the labels next to a marker at the appropriate x,y
position. I am assuming somehow it can be done on a scatter chart.

Many thanks for any advice

Phil





All times are GMT +1. The time now is 02:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com