Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Getting data labels right....
I have an XY Scatter chart plotting two columns of data. The data labels I
want to use for the points on the chart are in a third column, each row corresponding to the proper row for the data being plotted. How do I get the data labels to display the values in the third column? Thanks! Shawn |
#2
|
|||
|
|||
43fan,
These resources will help: (1) You can use Rob Bovey's XY Chart Labeler add-in located at: http://www.appspro.com/Utilities/ChartLabeler.htm (2) You can use John Walkenbach's Chart Tools add-in located at: http://j-walk.com/ss/excel/files/charttools.htm (3) You can use the following macro (load in a standard module): Sub AddLabels() Dim RngLabels As Range Dim Ser As Series Dim i As Long If TypeName(Selection) = "Series" Then Set Ser = Selection Set RngLabels = Application.InputBox(prompt:="Select the label range:", Type:=8) Ser.HasDataLabels = True For i = 1 To Ser.Points.Count Ser.Points(i).DataLabel.Text = RngLabels(i) Next i Else MsgBox "Select a series in a chart." End If End Sub In the dialog box, add the reference to the data source like "Sheet1!A1:A5". (4) You can use the techniques described he http://www.pdbook.com/index.php/exce...t_data_labels/ ---- Regards, John Mansfield http://www.pdbook.com "43fan" wrote: I have an XY Scatter chart plotting two columns of data. The data labels I want to use for the points on the chart are in a third column, each row corresponding to the proper row for the data being plotted. How do I get the data labels to display the values in the third column? Thanks! Shawn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using data as data labels | Excel Discussion (Misc queries) | |||
Excel should let me align data labels in different series (Excel . | Charts and Charting in Excel | |||
Resize data labels | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Help with pivot charts and data labels | Charts and Charting in Excel |