XY chart with labels
 

Country Volume - %
Germany 3,000,000 - 45%
UK 5,100,000 - 76%
Denmark 1,250,000 - 22%
France 1,500,000 - 38%
Belgium 2,000,000 - 85%

Given data above, I can easily create an X-Y chart based on volume and %.
But is it possible that when I mouse over to any particular point for the
data label to also display the country?

Thanks,
DSK

You can fake the chart tips that pop up, using the Auto Hover Labels
approach on Tushar Mehta's site (http://tushar-mehta.com).

You could also put permanent data labels on the points using the country
names, using the Chart Labeler on Rob Bovey's site (http://appspro.com)
or the Chart Tools addin on John Walkenbach's site (http://j-walk.com/ss).

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


DSK_7 wrote:

Country Volume - %
Germany 3,000,000 - 45%
UK 5,100,000 - 76%
Denmark 1,250,000 - 22%
France 1,500,000 - 38%
Belgium 2,000,000 - 85%

Given data above, I can easily create an X-Y chart based on volume and %.
But is it possible that when I mouse over to any particular point for the
data label to also display the country?

Thanks,
DSK