Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I plot an XY (scatter) graph with two Y axes? | Charts and Charting in Excel | |||
How do u set the PLOT AREA to nearest mm in Excel Scatter Graph . | Charts and Charting in Excel | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
Can I use xy scatter charts to plot absolute measurements? | Charts and Charting in Excel | |||
Bar Chart Label Sizes | Charts and Charting in Excel |