Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Scatter Charts
I am trying to do a simple scatter chart where one column of numbers
represents the series for the X-axis and another represents the y-axis and the plots are the combined points. I would like to assign a label to each point to make them easily identifiable as to what each point represents. Example: Ref X-Axis Y-Axis 1 14.5 11.0 would like this plot to have a label of 1 2 15.0 9.5 would like this plot to have the label 2 3 26.25 20.5 would like this plot to have the label 3 and so on. |
#2
|
|||
|
|||
To add the independent data labels . . .
You can use Rob Bovey's XY Chart Labeler add-in located at: http://www.appspro.com/Utilities/ChartLabeler.htm or John Walkenbach's Chart Tools add-in located at: http://j-walk.com/ss/excel/files/charttools.htm or you can use the following macro: 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". Last, you can use the process described he http://www.pdbook.com/index.php/exce...t_data_labels/ ---- Regards, John Mansfield http://www.pdbook.com "SauveC" wrote: I am trying to do a simple scatter chart where one column of numbers represents the series for the X-axis and another represents the y-axis and the plots are the combined points. I would like to assign a label to each point to make them easily identifiable as to what each point represents. Example: Ref X-Axis Y-Axis 1 14.5 11.0 would like this plot to have a label of 1 2 15.0 9.5 would like this plot to have the label 2 3 26.25 20.5 would like this plot to have the label 3 and so on. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scatter Chart Axis as text in C# Web appl | Charts and Charting in Excel | |||
XY Scatter charts | Charts and Charting in Excel | |||
i need help automating, or at least simplifying, my charts | Charts and Charting in Excel | |||
Can I use xy scatter charts to plot absolute measurements? | Charts and Charting in Excel | |||
Locking the scale ratio of X-Y axis in XY scatter charts | Charts and Charting in Excel |