Simple dot plot label question

**trytte** · 11-16-2009, 06:46 AM

I'm pretty certain I'm missing something obvious, but I just can't get this to work - I have a table consisting of countries and two values for each country, and I'd like to represent these values with a dot and have the country name as a label.

As in:

Sweden 10 0.4
Denmark 11 0.6
Norway 15 0.3

With a dot representing each country and then the country name as a label - like the first chart in this Freakonomics blog post: http://freakonomics.blogs.nytimes.co...index-measure/

(The best I can come up with is each label including every country in the table.)

**rwgrietveld** · 11-16-2009, 06:56 AM

Each Country is a new series. For 3 countries this isn't much work, but I have the idea that you will add more. Here is the example for your three countries.

**teylyn** · 11-16-2009, 06:57 AM

Hi,

you may want to download the XY Chart Labeler add-in. Works a breeze.

http://www.appspro.com/Utilities/ChartLabeler.htm

**teylyn** · 11-16-2009, 06:58 AM

Much better, Ricardo!

(But if you work with XY charts, the add-in is the tool to have. Download it anyway!!

)

**trytte** · 11-16-2009, 07:10 AM

Wow, thanks a lot everybody. I have ~25 countries, and I'd like for each dot to look the same except for the label, so it was far too much work to add them one by one - and I was certain I was just doing some simple mistake.

That XY Chart Labeler worked like a charm - thanks a lot for the tip!