Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default inserting specific points on a graph and label them?

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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default inserting specific points on a graph and label them?

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.
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default inserting specific points on a graph and label them?

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.
--
David Biddulph

"cj_69" wrote in message
...
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?



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default inserting specific points on a graph and label them?

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.

"David Biddulph" wrote:

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.



  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default inserting specific points on a graph and label them?

So you need to add a new point to your series, or a new series including
your new point.
--
David Biddulph

"cj_69" wrote in message
...
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.

"David Biddulph" wrote:

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.







  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default inserting specific points on a graph and label them?

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Del Cotter" wrote in message
...
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I easily label 200 different data points on a buble chart? Czajkowski Charts and Charting in Excel 3 February 7th 10 01:11 AM
How do I label data points in a scatter graph Justin[_3_] Charts and Charting in Excel 1 October 26th 07 10:32 PM
label invidual points in an XY scattergraph Apollyon Excel Discussion (Misc queries) 1 October 6th 06 01:52 AM
label points on an XY graph Eric Charts and Charting in Excel 2 November 28th 05 01:36 AM
Excel graphs with 1,000 or more points should not auto label SRE Jonathan Charts and Charting in Excel 0 June 9th 05 07:34 PM


All times are GMT +1. The time now is 10:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"