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.)
Last edited by trytte; 11-16-2009 at 07:11 AM. Reason: Question solved.
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.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Hi,
you may want to download the XY Chart Labeler add-in. Works a breeze.
http://www.appspro.com/Utilities/ChartLabeler.htm
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
Much better, Ricardo!
(But if you work with XY charts, the add-in is the tool to have. Download it anyway!!)
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking the
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks