Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DSK_7
 
Posts: n/a
Default 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

  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to put x axis values in the chart instead of x axis labels Sinclair Charts and Charting in Excel 1 June 21st 05 11:04 AM
How do I not include empty cell value chart labels in pie charts? JMarble Charts and Charting in Excel 1 May 13th 05 08:38 PM
Align Clustered Column Chart Category Axis Labels Stephanie Charts and Charting in Excel 1 April 7th 05 03:21 PM
How do I get my data labels on a pivot chart to retain their form. s de maia Charts and Charting in Excel 1 March 18th 05 03:34 AM
how can I fill labels in a chart, so that the grid lines don't in. peterk Charts and Charting in Excel 2 February 18th 05 01:52 AM


All times are GMT +1. The time now is 07:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"