inserting specific points on a graph and label them?

C

cj_69

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?
 
D

Del Cotter

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_trend_with_events.htm
 
D

David Biddulph

Click twice on a data point to select it, right-click, select Format Data
Point/ Data Labels/ select one or more of the options (series name, X value,
or Y value).
When you've added a label, you can select it and edit it, replacing the
existing text by new text which you type in.
 
C

cj_69

Sorry the i would like to insert a point that is not a point on the scatter
graph
so i want to add a point that is not already existing.
 
D

David Biddulph

So you need to add a new point to your series, or a new series including
your new point.
 
J

Jon Peltier

Even easier:

Set up the added data like this:

Label1 Label2
X1 Y1
X2 Y2

Copy the data, select the chart, use Paste Special to add the data as new
series, with series in columns. This gives you two series, each with one
visible point. Right click one of these, add data labels, using the series
name option. Select the other and press F4 to repeat last action (F4
probably won't work in 2007).

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top