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

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
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 do I plot an XY (scatter) graph with two Y axes? PeterAtLufbra Charts and Charting in Excel 2 April 4th 23 10:44 AM
How do u set the PLOT AREA to nearest mm in Excel Scatter Graph . fh Charts and Charting in Excel 0 June 3rd 05 01:07 PM
Adding more source data to existing scatter plot Tom Charts and Charting in Excel 1 March 21st 05 10:03 PM
Can I use xy scatter charts to plot absolute measurements? Wattie Charts and Charting in Excel 0 February 6th 05 03:29 PM
Bar Chart Label Sizes [email protected] Charts and Charting in Excel 2 December 27th 04 03:19 PM


All times are GMT +1. The time now is 06:18 AM.

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

About Us

"It's about Microsoft Excel"