Please HELP!!!! before I throw the computer out the window

[bstraw]

Hello all, New to this site but it looks like someone may be able to help, and I am so frustrated now I really need help. OK here is the question. I am making an xy scatter graph. I have 3000+ data points to get the line that I need. Now I want to add a symbol to one of the 3000+data points so it shows up, and also add a label to it. For simplicity sake lets say I have data in two columns, A and B, with 200 rows. I insert a xy scatter and it gives me a nice straight line. Now I want to select the data in Row 184 to show up as a point on the nice line in the graph, can this be done? AHHHHH please help
Thanks in advance

 

[bstraw]

I am trying to post the sheet on this board and not having any luck. I understand that e-mails may not be a great thing but my address is Byron.Straw@unco.edu If it is ok can you email me and I can attach the sheet and explain what is going on?

 

[bstraw]

Really need to get this done would even paypal a few $ if someone gets it

 

[bstraw]

Anyone?

 

[mikerickson]

You have columns A and B and you want the point on the graph A127,B127 to be highlighted.
To do this, leave C blank and in C127 put the formula =B127.
Then make the scatter graph and expand your data range to three columns.
The graph of series2 (from column C) will consist of your one point. and be a different color than series1 (from columnB).

 

[bstraw]

thanks mikerickson but for some reason it did not seem to work, any other ideas? I wish I could just click on a cell and the data point (cell that I click on) show up in the chart. I have been trying to resolve this for 14 hours now, either I am really dumb or something is just wrong

 

[mikerickson]

Are all the cells in C blank except for the one with the formula?
Is the data range = A1:C200
What do you mean by "doesn't work". What does it do (or not) that you don't want (or do)?

 

[bstraw]

all of my data is in columns A and B for example:
<table style="border-collapse: collapse; width: 143pt;" width="191" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 95pt;" width="127"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" width="64" height="17">Years</td> <td style="width: 95pt;" width="127">Diameter (mm)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">0</td> <td align="right">0</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">1</td> <td align="right">0.14</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">2</td> <td align="right">0.28</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">3</td> <td align="right">0.42</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">4</td> <td align="right">0.56</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">5</td> <td align="right">0.7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">6</td> <td align="right">0.84</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">7</td> <td align="right">0.98</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">8</td> <td align="right">1.12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">9</td> <td align="right">1.26</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">10</td> <td align="right">1.4</td> </tr> </tbody></table>the whole way to row 3768,
when I add the C colum it changes my line on the grapg as straight and just puts a red line near the bottom. The data changes at roww 100 to:
<table style="border-collapse: collapse; width: 143pt;" width="191" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 95pt;" width="127"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" width="64" align="right" height="17">100</td> <td style="width: 95pt;" width="127" align="right">14</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">101</td> <td align="right">14.033</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">102</td> <td align="right">14.066</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">103</td> <td align="right">14.099</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">104</td> <td align="right">14.132</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">105</td> <td align="right">14.165</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">106</td> <td align="right">14.198</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">107</td> <td align="right">14.231</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">108</td> <td align="right">14.264</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">109</td> <td align="right">14.297</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">110</td> <td align="right">14.33</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">111</td> <td align="right">14.363</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">112</td> <td align="right">14.396</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">113</td> <td align="right">14.429</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">114</td> <td align="right">14.462</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">115</td> <td align="right">14.495</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">116</td> <td align="right">14.528</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">117</td> <td align="right">14.561</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">118</td> <td align="right">14.594</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">119</td> <td align="right">14.627</td> </tr> </tbody></table>and so on

 

[mikerickson]

My test file works fine. As for the clicking, I prefer the control of the Double Click event.
put this in the code module for the sheet in question.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean)
    If Target.Column < 3 Then
        Columns(3).ClearContents
        With Target.EntireRow
            .Cells(1, 3).Value = .Cells(1, 2).Value
        End With
        Cancel = True
    End If
End Sub

Also, this macro will create the chart I'm talking about. Activate the sheet with the data in columns A and B and run the macro. It will delete anything in column C and put the first highlight from row 197. Thereafter, the double-click event above will determine which point is highlited.

Sub Macro1()
    With ActiveSheet
        .Columns(3).ClearContents
        Charts.Add
        ActiveChart.ChartType = xlXYScatterSmooth
        ActiveChart.SetSourceData Source:=Range(.Cells(1, 1), .Cells(.Rows.Count, 1).End(xlUp)).Resize(, 3), PlotBy _
            :=xlColumns
        ActiveChart.Location Where:=xlLocationAsObject, Name:=.Name
        With ActiveChart
            .HasTitle = False
            .Axes(xlCategory, xlPrimary).HasTitle = False
            .Axes(xlValue, xlPrimary).HasTitle = False
        End With
        .Cells(197, 3).Value = .Cells(197, 2).Value
    End With
End Sub

 

[bstraw]

anyway I can email you this sheet?

 

[mikerickson]

I really don't know charts. I'm just fiddling with the Chart Wizard and recording macros. I can get it to highlight a particular point on a scatter chart by adding a third column with only one data point in the column. The key that I see is that the third column should be blank (no "" , just blank) except for that one entry. (I also assume that columns A and B are not dependent on column C values.)

You have more experience with charts than I do, especially in relation to your needs. I hope that idea helps you.