On Wed, 12 Dec 2007, in microsoft.public.excel.charting,
cj_69 said:

Hi, i have excel 03 and have creating a xy scatter graph of frequency
response and i need to mark 2 specific points on the graph and label them.
Does anyone know how to do this?

Create the following table in a convenient part of your spreadsheet:

x1 y1 Comment1
x2 y2 Comment2

Select the first two columns (not the third, for now), and use Copy,
Paste Special to add them to your XY chart as a new series. When the
Paste Special dialogue invites parameters, choose these:

Add cells as: New series
Values (Y) in: Columns
(the odds are good that the default will guess wrongly, so change
it)
Series names in first row: NO
(unless you actually want to name the y column: if so, add a name
row in the table I suggest above)
Categories in First column: YES
Replace existing categories: NO

Now since you've only got two points, you may as well add the comments
manually: select the series and give it data labels. "Show value" or
"Show label" is not important, as we're going to alter these anyway.

Select one label, select it again until just that label is selected and
not the range. Click in the edit bar at the top of the screen and type
"=", then select the comment cell and Enter the formula. Now you have a
comment in the spreadsheet shown at the fixed point on the XY chart.
Alternatively, you can do it really manually and type the text comment
in the data label, replacing the value.

If you have a column of lots of comments or labels, you can use one of
the free add-ins that can be found on the web to automate this edit
process.

Kelly O'Day has a good example to show how you can do this at:

http://processtrends.com/pg_charts_t...ith_events.htm

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.