Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
hatzipet
 
Posts: n/a
Default XY Scatter with Custom Labels


I have a list of products, each with an X (a dollar amount) and a Y
value (a percentage). Is it possible to have each point labeled with a
custom value i.e.: Printer, or Digital Camera, rather than it being
labeled with just the values being plotted ($1,000, 2% or $500, 7%)?

Any ideas are appreciated.

Thanks,
Keith


--
hatzipet
------------------------------------------------------------------------
hatzipet's Profile: http://www.excelforum.com/member.php...o&userid=27891
View this thread: http://www.excelforum.com/showthread...hreadid=473920

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

You can edit the text of a label, to manually insert your desired labels. In
addition, there are third party Excel add-ins that allow you to apply labels from a
worksheet range to a series of data points. Two good ones a

Rob Bovey's Chart Labeler (http://appspro.com)
John Walkenbach's Chart Tools (http://j-walk.com)

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

hatzipet wrote:

I have a list of products, each with an X (a dollar amount) and a Y
value (a percentage). Is it possible to have each point labeled with a
custom value i.e.: Printer, or Digital Camera, rather than it being
labeled with just the values being plotted ($1,000, 2% or $500, 7%)?

Any ideas are appreciated.

Thanks,
Keith



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
Labels for Scatter Diagrams ksn Charts and Charting in Excel 1 July 2nd 05 04:46 PM
How to assign datalabels to a scatter chart, obtaining the labels. Jos Koot Excel Discussion (Misc queries) 1 April 22nd 05 01:11 PM
Custom data labels on a scatter plot Bradfro Charts and Charting in Excel 3 April 20th 05 01:25 PM
Moving labels in a scatter plot Ian Belcher Charts and Charting in Excel 1 March 30th 05 11:24 PM
How do I add column A data labels to a scatter of columns B and C? Christina1 Charts and Charting in Excel 3 March 27th 05 04:43 AM


All times are GMT +1. The time now is 04:42 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"