arc90 lab | tools: Link Thumbnail
Excel Help Forum
ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 10-07-2005, 08:05 PM
Baapi
Guest
 
Posts: n/a
Scatter Plot and Axes labels

if I have my data as
Sl. Production Quality
1. 10 10%
2. 20 30%
3. 56 56%
4. 98 12%

and want to know who is in the high Production/High Quality, High
Production/Low Quality etc.. the 4 areas, I can use the xy scatter plot.

but the points which represent these data cannot be labelled. How do I know
which point on the graph corresponds to which person (Sl. No.)?

OR

How do I label data points in an XY Scatter plot?
--
Baapi
Reply With Quote
  #2  
Old 10-08-2005, 12:05 PM
Andy Pope
Guest
 
Posts: n/a
Re: Scatter Plot and Axes labels

Hi,

Here are a couple of free addin for linking data labels to cells.

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

Cheers
Andy

Baapi wrote:
> if I have my data as
> Sl. Production Quality
> 1. 10 10%
> 2. 20 30%
> 3. 56 56%
> 4. 98 12%
>
> and want to know who is in the high Production/High Quality, High
> Production/Low Quality etc.. the 4 areas, I can use the xy scatter plot.
>
> but the points which represent these data cannot be labelled. How do I know
> which point on the graph corresponds to which person (Sl. No.)?
>
> OR
>
> How do I label data points in an XY Scatter plot?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


All times are GMT -4. The time now is 07:22 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0